Using Automation to Control Excel from Access
Posted on
11,018 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
When running slow stored procedures from Access it may be useful to have the application do something else rather than just show the hourglass. In this example a form flashes a message while the stored procedure executes, and then closes itself on…
Windows Explorer lets you open archive (tar and tgz) files like any other folder.
In VBA you can easily handle normal files and folders, but opening and indeed creating archive files takes a little more - and that you'll find here.
