How can I work with predefined set of projects whithout opening th

[Iglesias]

Hi,

I have a script that exportm me all the work made in more schedules in the
MS Project server (for billing purposes).

Unfortunately, I need to make the report on at least 20 schedules (and in
the future it can be about 49) and that means that the project managers needs
to close all of them the projects and then I must to open all those projects
only to run the report.

My question is:
How can I work with VBS with those MS project schedules data without opening
them? Thank you.

 

[Jack Dahlgren]

You can read them at the same time they are open for editing. No need to
have everyone close them.

-Jack Dahlgren

 

[Iglesias]

I don't expresed well myself:

I don't want to have opened the schedules to make the report. I need to know
how to make the report without opening (30) schedules. If there is any
command that helps me to call in the repository the selected schedule.
Nothing more. If not, I must to open one-by-one of them and take care that
they are not open by somebody else ... (that is almost impossible becuase my
project managers are around the world and always there are opened 3-8
schedules)

Thank you.

 

[Jack Dahlgren]

Certainly you can pull the schedule data from the project database.
What you use for this depends what information you want.
It will take reading some documents and understanding the database.
And, there shouldn't be a problem with reading data even if a schedule is
open. You can open an already open file as read-only.

-Jack

 

[Iglesias]

Thank you.
I want only to report in a de-normalized table (for pivot tables analysis
purposes)for the selected set of projects (in my portfolio):

ProjectAttr1
ProjectAttrn...
TaskAttr1
TaskAttrn...
Resource Attr1
(ResourcAttrn... in the future)
WorkDate
WorkHours (the data stored through PWA)
Also the week but I don't believe that in MSP vba is for that any function.
I resolve this in the Excel template.

It is the base to be able to bill each customer (in one schedule we can have
work for more customers and one customer can be managed in more projects
<), that's why I need to report from a set of projects together).

I want to make this vba report WITHOUT opening the referenced projects ...
It will be for me a great goal (saving at least 1,5 hours weekly). Do you
think that I can extract the data without opening the project schedules?
Thank you very much
Best regards,
Erik Iglesias Abella.