Tag Archives: Reference

No Thumbnail

Excel VBA, Sheet Reference Speed

In the article Excel VBA Working With Sheets, I’ve explained that there are 3 different methods for referencing sheets. I have run tests on these methods to determine the fastest way of referencing sheets. Before explaining the tests, I have briefly explained the different methods of referencing sheets.

No Thumbnail

Access VBA, Referencing Forms

In this article I will explain how you can reference access forms using VBA. For example: Form_MyTable1.Recalc Form_MyTable1.Requery Form_MyTable1.Controls.Item (1) Form_MyTable1.Width = 45 but before this can be done the Form_MyTable1 needs to be created. This can be done by following the steps below: – Step 1: Double

No Thumbnail

VBA Access Recordset, Object Library

If you are going to be working with the Recordset object in VBA for Access, there are 2 options. Early binding Late binding In the first method we add reference to the Access Object Library, before execution. It will run faster and we will have access to the VBA editor intellisense. On the other hand

No Thumbnail

VBA Access ADOX.Catalog, Object Library

If you are going to be working with the ADODX.Catalog object there are 2 options. Early binding Late binding In the first method we add reference to the ADOX (Microsoft ADO Ext for DDL and Security) Object Library, before execution. It will run faster and we will have access to the VBA

No Thumbnail

Tekle Open API: Get All Parts With Specific Class

This article explains how you can get reference to all existing objects in a Tekla Structure model with a specific class using the Tekla Open API in VB.Net. – Step 1: Add reference to the Tekla.Structures.Model library located in the path “C:Program FilesTekla Structures20.0ntbinplugins” and manually