resource names column in project

J

Jan De Messemaeker

Hi Roney,

You can't have this in the ResourceNames column but by running a VBA
procedure you can have it in a text field:

Sub For_Roney()
Dim Job as task
Dim Whodunit as assignment
for each Job in activeproject.tasks
If not Job is nothing then
Job.text7=""
for each whodunit in job.assignments
job.text7=job.text7 & whodunit.resourcename & "(" _
& cstr(whodunit.work/60) & ");"
next whodunit
if len(job.text7)>0 then
job.text7=left(job.text7,(len(job.text7)-1))
end if
end if
next job
end sub

Hope this helps,







--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
Roney said:
How can I have the resource names column show hours per task not
percentage?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top