Chapter 22. Working with Other Applications

IN THIS CHAPTER

Understanding Automation 335

Setting Object References 336

Creating Objects 338

Working With Automation Servers 340

Case Study: Using Excel Charts 345

Understanding Automation

Up to this point, we have shown you capabilities of Microsoft Access by itself. We can’t forget, however, that Access is part of the Microsoft Office suite of programs. One of the main purposes of an integrated suite of applications is to allow the programs to work together, letting each program do what it does best. The term for this is automation. VBA provides a code structure that allows you to create applications that can control other applications within the suite from any one application. But automation is ...

Get Microsoft® Office Access 2007 VBA now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.