Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-17-2014, 07:06 AM
Andrea Schanz Andrea Schanz is offline Resource Usage View - Is it possible to display resource names Windows 7 64bit Resource Usage View - Is it possible to display resource names Office 2013
Novice
Resource Usage View - Is it possible to display resource names
 
Join Date: Sep 2014
Posts: 3
Andrea Schanz is on a distinguished road
Default 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.
Attached Images
File Type: gif x.gif (46.9 KB, 18 views)
Reply With Quote
  #2  
Old 09-17-2014, 05:00 PM
JulieS JulieS is offline Resource Usage View - Is it possible to display resource names Windows 7 64bit Resource Usage View - Is it possible to display resource names Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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?
Reply With Quote
  #3  
Old 09-18-2014, 05:14 AM
Andrea Schanz Andrea Schanz is offline Resource Usage View - Is it possible to display resource names Windows 7 64bit Resource Usage View - Is it possible to display resource names Office 2013
Novice
Resource Usage View - Is it possible to display resource names
 
Join Date: Sep 2014
Posts: 3
Andrea Schanz is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 09-18-2014, 11:22 AM
JulieS JulieS is offline Resource Usage View - Is it possible to display resource names Windows 7 64bit Resource Usage View - Is it possible to display resource names Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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.
Reply With Quote
  #5  
Old 09-18-2014, 11:50 AM
Andrea Schanz Andrea Schanz is offline Resource Usage View - Is it possible to display resource names Windows 7 64bit Resource Usage View - Is it possible to display resource names Office 2013
Novice
Resource Usage View - Is it possible to display resource names
 
Join Date: Sep 2014
Posts: 3
Andrea Schanz is on a distinguished road
Default

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.
Reply With Quote
  #6  
Old 09-18-2014, 01:12 PM
JulieS JulieS is offline Resource Usage View - Is it possible to display resource names Windows 7 64bit Resource Usage View - Is it possible to display resource names Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Ah, thanks. Please keep us posted.
Reply With Quote
  #7  
Old 09-22-2014, 07:47 AM
JulieS JulieS is offline Resource Usage View - Is it possible to display resource names Windows 7 64bit Resource Usage View - Is it possible to display resource names Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Andrea posted the question to:

http://social.technet.microsoft.com/...ct2010custprog
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Resource Usage View - Is it possible to display resource names Resource Usage View bumpui Project 7 06-18-2014 05:32 AM
Resource Usage View - Is it possible to display resource names 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 01:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft