Using Automation to Control Excel from Access
Posted on
11,024 Points
4:36
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can launch Excel, create workbooks, and then programmatically manipulate those workbooks.
Video Steps
1. Create a reference to the Excel application object.
2. Write code that launches Excel, makes it visible, creates a workbook, and sets the value of cell A1 to "Hello World".
3. Run the code and watch it execute.
4. Explain that other commands can be used to programmatically control Excel.
Suggested Videos
If you want to save changes made programmatically to a reports Printer property do not use this syntax:
docmd.close acReport, Reportname, acSaveYes
I found that a simple "Welcome" screen/form added to a database makes it both more friendly and easier to use. Here is how I added one to a Microsoft Access database.
Please see the important note at the bottom of this article regarding compati…
Suggested Courses
Next Video:Combining Excel's Take and Filter Functions