Change multiple durations via VBA

[Peter Rooney]

Good morning, all!

I've been away from Project VBA for ages, now, so please forgive a probably
elementary question.
I want to replace all occurences of "1 day?" in a project plan with "1 day".
I'll probably use a for each loop, but what's the collection that refers to
all tasks in a project?
Also, will this only affect the individual tasks, and not the durations for
the task summaries?
Thanks in advance

Pete

 

[John]

Good morning, all!

I've been away from Project VBA for ages, now, so please forgive a probably
elementary question.
I want to replace all occurences of "1 day?" in a project plan with "1 day".
I'll probably use a for each loop, but what's the collection that refers to
all tasks in a project?
Also, will this only affect the individual tasks, and not the durations for
the task summaries?
Thanks in advance

Pete

Pete,
OK, I'm gonna make this real simple for ya. Go to Tools/Options/Schedule
tab and uncheck the box that says, "show that tasks have estimated
durations".

Problem solved, no VBA required.
John
Project MVP