Business Solutions VBA and Macros for Microsoft® Office Excel® 2007

Chapter 18. Automating Word

IN THIS CHAPTER

Early Binding	421
Late Binding	424
Creating and Referencing Objects	425
Using Constant Values	427
Understanding Word’s Objects	428
Controlling Word’s Form Fields	437
Next Steps	439

Word, Excel, PowerPoint, Outlook, and Access all use the same VBA language; the only difference between them is their object models (for example, Excel has a Workbooks object, Word has Documents). Any one of these applications can access another application’s object model as long as the second application is installed.

To access Word’s object library, Excel must establish a link to it. There are two ways of doing this: early binding or late binding. With early binding, the reference to the application object is created when the ...