Comparing the same task in two plans

[JimS]

Hi,

I've written some macros to compare two versions of a MSP 2000 plan to allow
me to home in on what has changed. I'm looking at extending the range of
comparisons for this but was wondering whether there is a smarter way of
comparing two tasks for differences. If not, then I'll have to code a lot of
ifs for the important fields.

Any thoughts

Cheers
Jim

 

[John]

Jim,
One of the first macros I wrote (several years ago) was a Project
compare macro. Since then (i.e. Project 2000), Microsoft came out with a
Compare Project Versions add-in (now a utility in Project 2003). My
macro directly compares two project files that are genetically related
and highlights, in red, all changes directly in each of the files. The
add-in version, which is downloadable for Project 2000 (go to:
http://www.mvps.org/project/faqs.htm
and look at FAQ 36 - Compare Project Versions), creates a new
independent Project file with fields showing the differences.

As far as writing your own macro, you should only need one "if"
statement. Just embed it in one or more loops as you cycle through each
task and field.

Hope this helps.

John
Project MVP

 

[JimS]

Thanks - I'll take a look at the add in and see if that can help me.
Ultimately, I'd like to also have the macro/mechanism update the master plan
with the changes, so I'll see how this helps.

Cheers
JimS