Using VBA to Save Time on Document Production and Troubleshooting

Once you understand the elements addressed in the preceding section of this chapter, you’re ready to start using VBA. As mentioned earlier in this chapter, find a file named Sample Macros.dotm in the practice files you can install from this book’s CD. That file contains two modules. One of those modules (named SampleMacros) includes a few of my favorite simple document production and troubleshooting macros. The other module (named AutomateUserForms) includes a couple of basic dialog boxes with related automation for use with some of the sample templates referenced in Chapter 20. (Note that dialog boxes are known in VBA as UserForms and are introduced later in this chapter.) Check ...

Get Advanced Microsoft® Office Documents 2007 Edition Inside Out 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.