<

Using Automation to Control Excel from Access

Posted on
10,782 Points
1,982 Views
18 Endorsements
Last Modified:
Experience Level: Beginner
4:38
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
Comment
Author:TechMommy
1 Comment
 

Expert Comment

by:bill201
Excellent and useful thanks a lot
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Join & Write a Comment

When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month