#1
|
|||
|
|||
Print Resource Charts
Hi
I am using Jack D's code to print individual resource charts (copied below). However I want to be able to filter on resource that belongs to a particular group only. How do I do this: Sub PrintResourceCharts() 'This macro will pring a gantt chart for every resource in the project 'It will automatically adjust the timescale to show all of the resource's activities 'Copyright Jack Dahlgren, Feb. 2002 Dim r As Resource Dim mystring As String ViewApply Name:="&Task Sheet" For Each r In ActiveProject.Resources If r.Assignments.Count > 0 Then mystring = r.Name FilterApply "Filter 1" 'Display Resource Name in Text3 on each task sheet printed SetTaskField Field:="Text3", Value:=r.Name SelectAll ZoomTimescale Selection:=True SendKeys "{ENTER}" FilePrintPreview ' MsgBox (r.Name) End If Next r End Sub |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Resource Calendars | caz46 | Project | 0 | 02-12-2011 05:31 AM |
Resource use on tasks | Proj03 | Project | 0 | 01-24-2011 01:40 PM |
Resource Overallocation Reporting | Mutso | Project | 0 | 11-05-2010 12:27 PM |
Word 2007 Color Charts Print in Grayscale | AgDad | Word | 4 | 10-12-2009 08:55 AM |
PowerPoint Presentation Resource | lux | Office | 2 | 07-28-2005 02:09 AM |