Managing VBA Projects

The preceding three VBA chapters gave you an eagle-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 2000, that means learning the underlying object models (page 1280) 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, stored in Normal.dot; in Excel, use the Personal Macro Workbook, Personal.xls.