<

Using Automation to Control Excel from Access

Posted on
10,954 Points
2,154 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
Author:TechMommy
1 Comment

Expert Comment

by:bill201
Excellent and useful thanks a lot
0

Featured Post

Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

How to use a bill paying spreadsheet created by yours truly.  Also a little background.  The download is available towards the bottom of the article and is named Pay-Bills.xltm. Feel free to use, or, as you wish.  Provided as is.
As you can union records, you can join field values. Presented here, DJoin offers increased speed and flexibility compared to the ancient ConcatRelated and similar functions. Further, it offers better read-out of Multi-Value fields.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month