30.2. Using Automation to Transfer Information

Automation is the most powerful and efficient way to communicate with another application. Each application that supports Automation offers one or more Component Object Model (COM) objects that you can access programmatically—usually an object representing the application, an object representing the various types of files the application produces, objects representing its major components, and so on.

For any Automation transaction, there's a server application that provides the information and a client application that receives it. (There's also another pair of terms for the two applications: the server application is also sometimes known as the object application, and the client application is ...

Get Mastering VBA for Microsoft Office 2007, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.