F
Ferreira, Marco
Hey
I wanna know how I can get the path of the task at MY TASK view.
Recently, we post this:
I need a help to do a macro in VBA to get all resume name to input in
customize text filed for each task.
I will explain with an example. I will show a WBS.
This colum that I
need
TASK NAME TEXT 1(Customize filed)
0 - NAME OF PROJECT Name of Project( or clean)
1 - Summary Task 1 Summary Task 1 (or clean)
1.1 - Sub summary Task 1.1 Summary Task 1 > Sub summary
Task 1.1
1.1.1 - Task 1 Summary Task 1 > Sub
summary Task 1.1
1.1.2 - Task 2 Summary Task 1 > Sub
summary Task 1.1
1.2 - Sub summary Task 1.2 Summary Task 1 > Sub summary
Task 1.2
1.2.1 - Task 3 Summary Task 1 > Sub
summary Task 1.2
1.2.2 - Task 4 Summary Task 1 > Sub
summary Task 1.2
2 - Summary Task 2 Summary Task 2 (or clean)
2.2 - Sub summary Task 2.2 Summary Task 2 > Sub summary
Task 2.2
2.2.1 - Task 5 Summary Task 2 > Sub
summary Task 2.2
2.2.2 - Task 6 Summary Task 2 > Sub
summary Task 2.2
Then, Jan answerd with a macro that do that:
for each anytask in activeproject.tasks
if not anytask is nothing then
if anytask.summary then
anytask.text1=anytask.name
else
anytask.text1=""
end if 'is summary
if anytask.outlinelevel>1 then
set SummTask=anytask
for Counter= 1 to anytask.outlinelevel-1
set summtask=summtask.outlineparent
anytask.text1=summtask.name & " > " & anytask.text1
next counter
end if 'outlinelevel
For each Asg in anytask.assignments
asg.text1=anytask.text1
next asg
end if 'nothing
next anytask
We wanna know how can this macro run at an enterprise field.
And also why, in some projects, this macro doenst work - like, it doesnt
show the path at task usage view, the macro stops at the middle of the
tasks...
Regards
Juliana
I wanna know how I can get the path of the task at MY TASK view.
Recently, we post this:
I need a help to do a macro in VBA to get all resume name to input in
customize text filed for each task.
I will explain with an example. I will show a WBS.
This colum that I
need
TASK NAME TEXT 1(Customize filed)
0 - NAME OF PROJECT Name of Project( or clean)
1 - Summary Task 1 Summary Task 1 (or clean)
1.1 - Sub summary Task 1.1 Summary Task 1 > Sub summary
Task 1.1
1.1.1 - Task 1 Summary Task 1 > Sub
summary Task 1.1
1.1.2 - Task 2 Summary Task 1 > Sub
summary Task 1.1
1.2 - Sub summary Task 1.2 Summary Task 1 > Sub summary
Task 1.2
1.2.1 - Task 3 Summary Task 1 > Sub
summary Task 1.2
1.2.2 - Task 4 Summary Task 1 > Sub
summary Task 1.2
2 - Summary Task 2 Summary Task 2 (or clean)
2.2 - Sub summary Task 2.2 Summary Task 2 > Sub summary
Task 2.2
2.2.1 - Task 5 Summary Task 2 > Sub
summary Task 2.2
2.2.2 - Task 6 Summary Task 2 > Sub
summary Task 2.2
Then, Jan answerd with a macro that do that:
for each anytask in activeproject.tasks
if not anytask is nothing then
if anytask.summary then
anytask.text1=anytask.name
else
anytask.text1=""
end if 'is summary
if anytask.outlinelevel>1 then
set SummTask=anytask
for Counter= 1 to anytask.outlinelevel-1
set summtask=summtask.outlineparent
anytask.text1=summtask.name & " > " & anytask.text1
next counter
end if 'outlinelevel
For each Asg in anytask.assignments
asg.text1=anytask.text1
next asg
end if 'nothing
next anytask
We wanna know how can this macro run at an enterprise field.
And also why, in some projects, this macro doenst work - like, it doesnt
show the path at task usage view, the macro stops at the middle of the
tasks...
Regards
Juliana