Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-17-2011, 03:21 AM
OTPM OTPM is offline Print Resource Charts Windows 7 32bit Print Resource Charts Office 2010 32bit
Expert
Print Resource Charts
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default 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
Reply With Quote
Reply



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
Print Resource Charts PowerPoint Presentation Resource lux Office 2 07-28-2005 02:09 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:05 AM.


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