Tag Archives: Automation

Excel VBA, Export Worksheet to Blank Access Table

In this article I will explain how you can export values from an excel worksheet to a new blank 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

No Thumbnail

VBA, Open Access Database From Excel

In this article I will explain how you can open an existing Access database from Excel using VBA. If you wish to only import the data into excel you could use the topic covered in the article below: Excel Connect To External Data (Access Database ) In

No Thumbnail

VBA, Excel Automation From Other Applications

In this article I will explain how you can automate an Excel workbook from another application. There are basically two methods for automation: Early binding Late binding I have explained the difference between these two methods when I was explaining about word automation: VBA, Automating

No Thumbnail

VBA, Write Excel Values to Word Document

In this article I will explain how you can write data from an excel workbook to a word document. The first step in doing this is to determine where the code is going to be written. There are 3 options: In the excel workbook In the

No Thumbnail

VBA, Automating Word From Excel

There are 2 methods for initiating a word application from excel using VBA: Early Binding Late Binding Basically in early binding we define what object we are creating reference to before program execution. In late binding, the program won’t know what we are creating reference to

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

Access VBA, Import Excel Worksheet to Existing Table

In this article I will explain how you can import values from an excel worksheet to an existing table in Access using VBA. – DoCmd.TransferSpreadsheet: The values in the excel worksheet are imported using the DoCmd.TransferSpreadsheet Method: Syntax: Call DoCmd.TransferSpreadsheet(TransferType, SpreadSheetType, TableName, Filename, HasFieldNames, Range) TransferType: The

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