generate a seperate tif file per resource

[Yohan]

Basically I want to generate a report on task usage. The report will
generate the tasks for each resource within a date range. The trick
here is I want to generate a separate tif file for each resource. I
was able to create a page break for resources but that gives me only
one tif file. because we have more than 100 resources it takes so much
time to do this for each resource. Is there a way to write a code to
automatically generates tif file for each resource in the resource
sheet filtering it by date range, then save all those tif files to a
file?

 

[Rod Gill]

Hi,

In VBA you can create Gif files of the active View, but not tif files.

If you can create what you want to see for one Resource in Project, then
Project VBA can capture a Gif file and loop thru all Resources. I doubt
anyone has code that already does this, but creating it is not difficult.
The time taken will be in getting the image as you want it and handling your
local environment (Folder locations and security etc).

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com