Microsoft Project

This site is here to provide information about how to get the most out of Microsoft Project. You will find sections on writing macros to automate Microsoft Project, a brief discussion on calculated fields and a section which documents the new features available in Project 2002.

I've also just started a blog which has some VBA tutorials and the like which complements the articles here. You can go to the blog here: Jack's Project Blog

Please let me know if there is something you would like to see here.

-Jack Dahlgren

Project Versions:

Project comes in many different versions. The information here is rather brief. To be honest, the difference between Project 2002 and 2003 (at least in the standard version) is so small that I hardly bother to upgrade.

If you are using Project Server, the differences are more meaningful. I would even classify Project Server 2003 as a just a big service pack for 2002 which fixes many of the problems and bugs which were in 2002. That and an upgrade to WSS.

To Microsoft Home

Versions:

Project 2003 - The latest available version

Project 2003

Project 2002 - What I'm using mostly

Project 2002

Project 200x - What is coming up (Sorry, no information yet)

Project 200x
VBA and Macros:

There are many things that people would like project to do which are not built in to the standard tool. Fortunately, there is a way to get project to do almost anything that you want. This is through the use of VBA (Visual Basic for Applications) which is Project's built-in programming language. It is common with the other Microsoft Office Tools such as Excel and Word so that you can interoperate with those tools to extend the capabilities of Project. I have a number of examples of this available to get you started with it.

Follow this link to a page which has information about writing and using macros and several examples. Source code is included for all examples.

To Macros Page
Other Macro Information:

Example with Excel - A free Monte Carlo Simulation macro which illustrates how Project and Excel can work together.

Monte Carlo Simulator

Macros or Calculated Fields - Project 2000 introduced calculated fields. What they allow you to do is use any of the custom fields (Text, Number, Date, Cost, Flag ...) and use a formula to calculate what is displayed in that field. They are often a good replacement for a macro. This page describes when you would prefer one over the other.

Macros vs. Calculated Fields

Calculated Field FAQ - There are some common problems people have with Calculated fields. T his FAQ answers some of the Frequently Asked Questions.

Calculated Fields FAQ
Scheduling with Excel:

This part of the site is mostly concerned with Microsoft Project, but that doesn't mean you have to use it. Often I find that other tools such as Powerpoint or even Excel are more suited to a particular situation. If you fall in this category I've put together a sample file which shows how you can use things like conditional formatting and formulas to use Excel as a scheduling tool.

Follow this link to a page which has information about writing and using macros and several examples. Source code is included for all examples.

Using Excel for Scheduling
Links and other Information:

I am not alone. Here are some links to other useful MS Project Pages:

Links

Can't find it here?
Google
 
Web masamiki.com

Send me mail at: JackD@mvps.org


Return To Top Page