Microsoft Excel 2019 VBA and Macros, First Edition

CHAPTER 20Automating Word

In this chapter, you will:

• Use early and late binding to reference a Word object

• Use the New keyword to reference the Word application

• Use the CreateObject function to create a new instance of an object

• Use the GetObject function to reference an existing instance of Word

• Use constant values

• Be introduced to some of Word’s objects

• Control form fields in Word

Word, Excel, PowerPoint, Outlook, and Access all use the same VBA language. The only difference is their object models. For example, Excel has a Workbooks object, and Word has Documents. Any one of these applications can access the object model of another of the applications, as long as the second application is installed.

To access Word’s object library, Excel ...