Parameterising a project

[Dave]

Hi

Does anyone know how I can control my MSP schedule via a few
"external" parameters? What I'd like to do is set up a list of
parameters somewhere which then set the value in the work field for
each task in the schedule.

Ideally, I'd do this without using VBA, but if this is the only way
then so be it!

Thanks in advance for any help.

Dave

 

[JackD]

Sure I think I know how to do something like that using VBA. But you will
have to be more specific about what you want If I were you I'd simply put
the parameters in the project task (task0) or one of the custom properties
so you don't need to deal with "externals" and you could edit right in
project.

Here is a brief example:

Sub test()
Dim t As Task
Dim ts As Tasks
Dim asgt As Assignment
Dim asgts As Assignments
Set ts = ActiveProject.Tasks
For Each t In ts
If Not t Is Nothing Then
If Not t.Summary Then
Set asgts = t.Assignments
For Each asgt In asgts
asgt.Work = asgt.Work *
ActiveProject.ProjectSummaryTask.Number1
Next asgt
End If
End If
Next t
End Sub

To get from here to where you want to be you need to determine what
parameters you want to use, which values you want to change, how you deal
with duration, what to do with actuals or completed tasks, whether you want
to have undo or reset capabilities...

When you figure that out, writing the code will be simple.