2007 Microsoft® Office System Inside Out

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 find on 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. (Note that dialog boxes are known in VBA as UserForms and are introduced later in this chapter.) Check out these macros and UserForms as examples, or use them as jumping off ...