Microsoft® Office Project Server 2003 Unleashed

Using VBA Macros

Microsoft Project 2003 gives you the ability to automate tedious, repetitive, or complex tasks through the use of macros. A macro is essentially a series of commands or instructions that you can save and run whenever you need to by pressing a key combination or by clicking an icon.

Each instruction or command within a macro is executed via a programming language called Visual Basic for Applications (VBA). Although this language is basically a watered-down version of Visual Basic, there is almost no limit to the types of tasks that can be performed within Microsoft Project and even beyond.

In fact, VBA is so powerful that it could almost be used to create standalone applications, aside from executing from within Project. You have ...