Category Archives: Automation

No Thumbnail

Access VBA Get Field Names

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

No Thumbnail

Word VBA, Save Table as JPEG

In this article I will explain how you save a word table as a JPEG using VBA for word. Unless if you are willing to using windows API functions, I have yet to find a direct method for doing this in VBA for word. The

No Thumbnail

Check If Table Exists, Access VBA

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

Get Field Types in External Access Database, VBA Automation,

In this article I will explain how you can get the types 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.I’ve explained this in the article below VBA, Open Access Database From

VBA, Create New Access Database From Excel

In this article I will explain how you can create a new (blank) access database from Excel. There are 2 methods for getting this done: Late Binding Early Binding In early binding we add a reference to the Access Object Library. The benefit of using early binding

VBA Access Create Table in External Database (Automation)

In this article I will explain how you can create a table in an external access database using VBA. Before creating a table you will need to connect to an external database. You could either create a blank access database using the topic covered in

No Thumbnail

VBA Get Table Names in External Access Database (Automation)

In this article I will explain how you can get the names of all the tables in an external access database using VBA. The first step would be to connect to an external database. I’ve explained this in the article below: VBA, Open Access Database From