<

Using Automation to Control Excel from Access

Posted on
11,024 Points
2,224 Views
18 Endorsements
Last Modified:
Published
Experience Level: Beginner
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.

18
Author:TechMommy
1 Comment

Comment

by:bill201
Excellent and useful thanks a lot
0
When adding new VBA features to a workbook, some parts may be difficult but you struggle through it because it's important to you or to someone you're helping. During that struggle you may say to yourself that "I wish I could find an easier way". Ho…
A while back I wrote an article about the Power Query Editor and PowerBI (https://www.experts-exchange.com/articles/37938/PowerBI-and-the-Query-Editor-Save-time.html).  I have realized that my coworkers primarily use Excel and So have changed the ar…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month