Logic to loop through the MPP

[prashanth.sharangapani]

Dear Friends,

I need your help to quickly fix a problem. I need a routine to loop
through the MPP through all task names, search for a particular task
name, and update the 'Work' associated with it.

My tasks are laid out as under (of course, this does not matter, but
just giving you some information on my current problem) -

Task A
Development
Review
Rework

The problem is that the 'Review' and the 'Rework' work hours have been
interchanged. It is a huge MPP and I cannot reverse the numbers
manually.

Request help! I need to baseline the schedule tomorrow.

Thanks,
Prashanth

 

[Jan De Messemaeker]

Answered in the other newsgroup (you see, crossposting does not help)

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[prashanth.sharangapani]

Dear Jan,

Thanks for the code! I apologize for the cross posting. Last time I
asked for a help on the other forum with regards to VBA, I was asked
to post it here - and I did not receive any responses. However, the
other forum is the one that is really active and I was more hopeful of
an answer there.

Thanks again!

Prashanth

 

[Jan De Messemaeker]

No Problem!

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf