A dictionary is an object in VBA (similar to a collection) that stores data like an array. It can be used to store data of any type except an array. A VBA dictionary has two parts: Key Value …where key is simply a reference to the
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.
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
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
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
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