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?
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 "Yohan" wrote in message news:c3ee84ca-79e5-431b-bbae-ace5e4b5e09d@p31g2000prf.googlegroups.com... > 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?
