VBA and PERT under MP2000

[Alain R.]

Hi,

I would like to write a macro under MP2000 which :

- Select table "PA_PERT ENTRY" (PERT entry shee) from anywhere (table,
graph,...) i am.
- for each row :
- copy "Duration" to "Expected Duration"
- copy to "Pessimistic Duration", ("Expected Duration" * 1.3)
- copy to "Optimistic Duration", ("Expected Duration" * 0.9)

How can i do that ?
thanks for your help,
Alain

 

[Jan De Messemaeker]

Hi Alain,


First, Cross-posting is perfectly useless. All NGs are read, mostly by the
same people.

The question is not how but why should you do that?
Why bother about rows and columns?
The only problem I have is which column is Expected duration?
Which column is Pessimistic duration?
Which Column is Optimistic duration?
(If you have them in a table, double-click to se etheir real name)
Let us suppose they are Duration2, Duration3 and Duration4.

Then the routine looks like this:

For each job in activeproject.tasks
if not job is nothing then
if not job.summary then
job.duration2=job.duration
job.duration3=job.duration*1.3
job.duration4=job.duration*0.9
end if 'summary
endif 'nothing
next job

Hope this helps,


--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620