O'Reilly logo

Special Edition Using Microsoft® Office XP by Woody Leonhard, Ed Bott

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

Managing VBA Projects

The preceding three VBA chapters gave you an eagle's-eye view of how to put macros to work in your office. After you move beyond the fundamentals of VBA, becoming truly productive is mostly a question of mastering the vocabulary. In the case of Office XP, that means learning the underlying object models of each of the Office applications. Like any language, VBA gets easier with practice. As you work with VBA and build up a library of macros and code that you want to reuse, managing the collection becomes a challenge.

Storing Projects

When you begin writing macros in Word and Excel, it's easiest to store them in the projects provided by the macro recorder. In Word, that's the Normal project (by default), stored in Normal.dot, ...

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