Writing Microsoft Project Code with Visual Basic for Applications

PM Milestone Project Management Templates

PM Milestone 7000 Business Templates

Get Instant Access

Using the Visual Basic Editor 906

Understanding the Microsoft

Project Object Model 912

Creating Macros 916

Debugging Macros 921

Creating UserForms 926

Extending and Automating

Microsoft Project 932

If you read Chapter 27, "Automating Your Work with Macros," or if you've ever created a macro in Microsoft Office Project 2003, you already know that Visual Basic for Applications is one of the most powerful features of Project 2003. But there is much more to VBA (as it is more commonly called) than creating macros to automate repetitive, tedious, or complex tasks.

Note Although Visual Basic for Applications is used to collectively describe the programming language and environment included with Microsoft Project, the language itself is Visual Basic. For the remainder of this chapter, Visual Basic is used to refer to the language and its elements.

For additional information about Visual Basic, see Chapter 30, "Understanding the Visual Basic Language."

After reading this chapter, you will be able to:

• Edit or expand upon macros you have recorded.

• Find and fix errors in your macro code.

• Create your own forms and dialog boxes for user interaction.

• Access Microsoft Project features from other programs, such as Microsoft Office and Visio, or even from Web pages.

• Use external libraries to provide additional capabilities to your macros.

For more information about working with external data and other items outside the VBA environment, see Chapter 32, "Working with Microsoft Project Data."

Before you can tap into the power of Visual Basic for Applications, though, you need to learn more about the Visual Basic Editor and development environment.

Was this article helpful?

0 0
Project Management Made Easy

Project Management Made Easy

What you need to know about… Project Management Made Easy! Project management consists of more than just a large building project and can encompass small projects as well. No matter what the size of your project, you need to have some sort of project management. How you manage your project has everything to do with its outcome.

Get My Free Ebook

Post a comment