Excel 2007 VBA Programming with XML and ASP

Chapter 15Chapter 15

Using Excel VBA to

Interact with Other

Applications

Launching Applications + Moving between Applications

+ Controlling Another Application + Other Methods of

Controlling Applications + Understanding Automation +

Understanding Linking and Embedding + Linking and

Embedding with VBA + COM and Automation + Under-

standing Binding + Establishing a Reference to a Type

Library + Creating Automation Objects + Using the

CreateObject Function + Creating a New Word Document

Using Automation + Using the GetObject Function +

Opening and Modifying an Existing Word Document +

Using the New Keyword + Using Automation to Access

Microsoft Outlook + Chapter ...