O'Reilly logo

2007 Microsoft® Office System Inside Out by Microsoft Corporation

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required