In this chapter, you found out how to use macros in Project. In particular, you now know how to do the following:

♦ Create macros

♦ Assign shortcuts to macros to make them easy to run

Chapter 25 explains how to customize Project using VBA.

Customizing Microsoft Project Using VBA and Active Scripting

As you saw in Chapter 24, a macro is an automated set of instructions that can help you accomplish a specific task in Project. Macros are especially useful for completing tedious, repetitive tasks. You can record a macro in Project, or you can produce even more powerful automation by writing your own Visual Basic for Applications, or VBA, code.

For example, suppose that you need to increase the work for every task in your project that is assigned to a new, less experienced resource. If you had to accomplish this manually, you could edit every task to which this resource is assigned in your project and modify the assignment's work field. If this were a large project with several hundred tasks, you could see how this could take you hours to accomplish. It is easier to write some VBA code and then take just a few seconds to run the code. Furthermore, once you write your code, you can reuse it as many times as you like. If this idea appeals to you, customizing Project using VBA code is definitely worth exploring.

In This Chapter

Filtering to see critical tasks and resource assignments

Adjusting work using code

Customizing the Project Guide

In this chapter, you find the following three case studies, which show the benefits of customizing Project 2003 using code:

♦ Writing VBA code to filter all tasks on the project's critical path that should have finished by the current date, but have not.

♦ Increasing the work value for a particular resource in the project for all tasks that have not yet completed.

♦ Customizing the Project Guide to incorporate your company standards into the project initiation process.

This chapter is not intended to be a comprehensive VBA reference guide for Project. Instead, its purpose is to introduce you to many concepts of automating Project, and to help you "get your feet wet" in the world of writing custom code.

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