Chapter 17: Creating Word Documents with Excel VBA
When dealing with VBA for Excel, you'd be forgiven for thinking that your coding would limit you to working within Excel only. However, if you think carefully about the role of VBA within Office Suite, you'd realize that it is common to all the applications within the suite.
Knowing this, a new set of possibilities opens up. You can, for instance, capture data in Excel via a user form, and then automatically export it to a Word document. The beauty of this is that everything is executed in the background. In other words, you don't need to manually copy data from Excel, search for the correct Word document to paste this information, save the file, and then close Word again.
In this chapter, we will cover the following recipes:
- Creating a new instance of Word
- Writing and formatting text
- Copying data into Word
- Using templates and bookmarks
By the end of this chapter, you will be able to...
