<

Using Automation to Control Excel from Access

Posted on
10,889 Points
2,089 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

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Join & Write a Comment

As a person who answers a lot of questions, I often see code that could be simplified, made easier to read, and perhaps most importantly made easier to maintain if the code was modified to use the Select Case statement. This article explains how to…
This following write-up describes a different way to copy Lotus Notes Calendar to Outlook. Along with this, we will also learn the reason behind this NSF to PST migration. Users can prefer different procedures as per their convenience.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month