Controlling Other Applications

VBA enables you to control other Office applications—in fact, any application that uses VBA as a macro language, or any application that has been designed to make its internal functions available to other programs (or "exposed"), can be controlled directly via VBA. For example, it's possible (but difficult) to control Outlook 2002 from Word, because Outlook has "exposed" parts of its interface.

What should you call applications that can be controlled by other programs? Microsoft has a long history of terminology changes in this arena. You might hear the terms OLE Automation Server, ActiveX Object, ActiveX Container, or COM Server and they all more or less refer to this type of application. If you hear that an application ...

Get Special Edition Using Microsoft® Office XP 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.