Resource Pool and Password Protected Sharer Files in a Master Proj

[srea]

We currently have 1980 Project files and 7 Resource pools. I want to
password protect the project files, but we open the resource pool and the
sharer files into a Master Project in order to export the data into Excel.
This means that if the sharer files are password protected in order to open
them into a Master Project the password would have to be entered 1980 times
everytime we exported (currently twice a week). Does anyone know a way
around this? Is there a way to just enter the password once without removing
the password protection form the sharer files?

 

[Rod Gill]

I would write a macro, one for each Consolidated file. Use it to create a
new master each time, but when inserting a project, have the Link option
OFF. This copies all data and consolidates resource information. So, for
reporting or exporting to Excel it is quicker and far less likely to cause
file corruptions. You can record this macro. Try recording a simple one of a
master file with two projects only. Then copy paste the code for one
inserted project (once it works) once for each project to be inserted and
edit the path and password.

Oh, and you can specify a password in the macro!

This technique will also allow one project to belong to more than one
resource pool and consolidated file.

Alternatively, it looks like you could usefully use Project Server!

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx