#1
|
|||
|
|||
Resource Usage View - Is it possible to display resource names
In Project 2013, does anyone know how to display the resource names for each task. Using VBA I can display the resource name, but not all the resource names assigned to each task for each resource listed.
|
#2
|
|||
|
|||
Andrea I'm afraid I don't follow. You are in the Resource usage view so "Site_BMorgan" is the resource's name. Have you looked at the Task usage view?
|
#3
|
|||
|
|||
In the example provided, looking at KBroome, I would like to see, in the Resource Usage view, all the resource names assigned to each task to which she is assigned, for example Task ID 54 Subscription Overview is not only assigned to KBroome but to other resources as well. Yes, I can see this in a Task view, but need to see it in the Resource Usage view. Using VBA, I am able to assign ResourceName to the Text2 field but would like to assign ResourceNames to this field, however it does not appear in the pick list in VBA. I was hoping someone could tell how to do this with VBA.
|
#4
|
|||
|
|||
What you see in the Resource usage view is not tasks - it is assignments. So, you'd need to loop through each assignment (not task) and write the data. I am not a coder, so my suggestion is to post your question (including what release of project you are working with) to the Forum for project customization:
http://social.technet.microsoft.com/...ct2010custprog If you do post there, if you could post back to this thread with the thread url from the TechNet forum - that would be very helpful. |
#5
|
|||
|
|||
Thanks Julie. I actually am using Assignment:
Sub CopyResourcesToText2() Dim r As Resource, A As Assignment For Each r In ActiveProject.Resources For Each A In r.Assignments A.Text2 = A.ResourceName Next A Next r End Sub I will take your advise and post to the Forum for project customization. |
#6
|
|||
|
|||
Ah, thanks. Please keep us posted.
|
#7
|
|||
|
|||
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Resource Usage View | bumpui | Project | 7 | 06-18-2014 05:32 AM |
Inactive tasks and resource usage view | codeghi | Project | 1 | 05-05-2014 06:59 AM |
Resource Usage view does not correctly export to a Visual Report | cergon | Project | 3 | 04-25-2014 06:10 AM |
How to enter names in Resource Pool/names | pstein | Project | 1 | 03-26-2012 07:37 AM |
Resource Usage sheet - options | Andy Bain | Project | 1 | 11-05-2010 12:42 PM |