• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

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, or in the current document. Excel reverses the defaults: A recorded macro goes into either the currently open workbook (by default), or the Personal Workbook known as Personal.xls.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint