T
TroyS
Within PS2007
I want to be able to:
1) find a task where a task flag = Yes
2) Take the formula field from the task located above where the formula
resolves to a value (eg. Under Budget, Over Budget)
3) Save it to a project level text field to display in PWA Project Center
I have 2-3 sections of the project task template, where i allow people to
update time to a single time entry task, a section where i manage cost
resources and another section that is more of a full blown WBS which i
manage as %Complete. I can't use TaskID=0 as it would include essentially
duplicate effort between the time entry task and the detailed WBS.
Based on a Task that I flag I want to communicate that as my status of the
overall project in Project Center by setting a Project Level Field..
Because i may insert my detailed wbs or other cost tasks on any task id, i
need to be able to set a flag at the task to 'find' the task and copy the
results of the formula to the project level field so that i can ignore my
time entry task or my cost resource tasks....
as a newbie to vba, anyone have some ideas on how to tackle?
I want to be able to:
1) find a task where a task flag = Yes
2) Take the formula field from the task located above where the formula
resolves to a value (eg. Under Budget, Over Budget)
3) Save it to a project level text field to display in PWA Project Center
I have 2-3 sections of the project task template, where i allow people to
update time to a single time entry task, a section where i manage cost
resources and another section that is more of a full blown WBS which i
manage as %Complete. I can't use TaskID=0 as it would include essentially
duplicate effort between the time entry task and the detailed WBS.
Based on a Task that I flag I want to communicate that as my status of the
overall project in Project Center by setting a Project Level Field..
Because i may insert my detailed wbs or other cost tasks on any task id, i
need to be able to set a flag at the task to 'find' the task and copy the
results of the formula to the project level field so that i can ignore my
time entry task or my cost resource tasks....
as a newbie to vba, anyone have some ideas on how to tackle?