Category Archives: Automation

VBA Add Fields to External Access Database (Automation)

In this article I will explain how you can add fields to a table in an external access database using VBA. The first step would be to connect to an external database. The article below explains how you can connect to an existing database: VBA, Open

Excel VBA, Export Worksheet to Existing Access Table

In this article I will explain how you can export values from an excel worksheet to an existing Access table. – Step 1: The first step would be to connect to an existing access database or create a new access database. In this example we will be

No Thumbnail

Word Automation VBA, Common Errors

In the article below I’ve explained how you can automate a word document from another application using VBA: VBA, Automating Word From Excel Though the automation process itself is quite straight forward, there are many things you will need to keep in mind. Consider the code below: ActiveDocument.Tables.Add

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

VBA Access Object Library

If you are going to automate Access from another office application using VBA there are 2 options. Early binding Late binding In the first method we add reference to the Microsoft Access Object Library, before execution. It will run faster and we will have access to the VBA editor intellisense. On the other hand

Get Field Names in External Access Database, VBA Automation

In this article I will explain how you can get the names of all the fields in a table in an external access database using VBA. The first step would be to connect to an external database. In the article below I’ve explained this in the article

No Thumbnail

VBA Access Get Field Types

In this article I will explain how you can get the types of all the fields in a table in an access database using VBA. – Get Field Types: The access database used in this example has a table with the name “MyTable1”: Note: You may need to add reference to the Microsoft

No Thumbnail

Check If Field Exists, VBA Access

In this article I will explain how you can check if a field exists in an access database using VBA. Previously in the article below I’ve explained how you can get the name of all the fields in a table in an access database using

No Thumbnail

VBA Access Add Fields

In this article I will explain how you can add fields to a table in an access database using VBA. If the database does not contain any tables, you can use the topic covered in the article below to create tables for it: VBA Access Create