Copying Percentage complete to Master Plans

[Johnathan_]

Hi,

I work with a series of seperate MS Project 2003 plans. There are several
team plans on which individual teams update their % complete progress and
start and finish dates. These plans are detailed and go up to ouline levels 5
and above.

There is also a "master" plan which shares the same outline level 5 tasks as
these team plans but does not concern itself with lower levels of detail.
What I need to do is take the % complete from each of the outline level 5
tasks in each of these team plans and copy them into the outline level 5
tasks in master plan.

Since there are so many team plans, I dont want to create an external links
between each of the team plans and the master plan (I know I can transfer %
complete this way) because there are hundreds of lines and it will break if a
task is deleted/changed.

I would like to write a macro for the master plan which takes the level 5
task for each team plan and transfers it to the master plan.

I think this is possible? How difficult would this be? I would really
appreciate if someone could suggest how I would go about this. I am quite
comfortable with VBA programming and can pick it up easily - I just need some
help to set me off. Otherwise can you suggest any alternatives to how I can
achieve this?

Many Thanks in advance,
Johnathan_

 

[Jan De Messemaeker]

Hi Johnathan,

IMHO VBA is indeed the right solution.
The major difficulty is to find all the projects and open them in turn.
Either you use a list of addresses or when they are in a single directory
you can use teh Dir function to find them in turn.

Once a subproject and the overview project are open you have to make sure
you find the corresponding tasks. It would be fine if they share the same
(and unique) name then uyou could address them as theproject.tasks (Name),
then copy what you need to copy.
If the names ae not uniquye you have to define a unique identifier for
instance in a custom field..

It's not just about VBA, it's a bit of analysis before.

And BTW if you know VBA you will know the Object Browser is an invaluable
help in finding out about all the objects - I feel I knew VBA the day
somebody pointed me oin that direction!


Do not hesitate to come back with detailed questions - but may I ask you to
posyt them in the project.developer newsgroup?

Greetings,

 

[Dean C]

1. Evaluate whether the summary progress shown in your subproject tasks truly
represents the progress. See my response to the topic "Progress" in this
newsgroup. If you are interested, I'll send you a sample file.
2. Create a consolidated schedule of the schedules that have tasks to be
rolled up. If you use my custom fields, be sure to copy them to every
subproject. I have a macro that will do that for you too.
3. (optional) Create a custom field that concatenates a short name for the
subproject and subproject uniqueId. The uniqueid in the consolidated schedule
does the same thing, but you might like to know the source of the task in
question without displaying the Project field.
4. In the consolidated file, create a table that contains the uniqueid or
the custom uniqueid, name, actual start, actual finish, start, finish,
duration and either actual duration, or the summary duration calculated from
my custom fields.
5. Filter for the tasks in question.
6. Copy the name and uniqueid to fields in your master and assure that the
two files are aligned by comparing the pasted data to the master name and a
previously copied uniqueid.
7. Copy and paste the remaining data.
8. Once you have created the fields, etc., it will be easy enough to verify
alignment and copy and paste data that a macro may not be necessary or
prudent. If you decide to do a macro anyway, be sure to include an alignment
check.