M
Mark Main
I have a master plan that has 20 inserted project plans--2 of these project
plans are password protected.
I work in the PMO and I have a working macro that I manually run at night,
which scans the various plans and performs a series of quality checks (error
checks) and updates Text1 with notes for the project managers to clean things
up. They really like the tool, but I want to go home earlier and since I
need Write access, I really need to be scheduling this at 3:00 AM.
I know how to program if VB6 and MS Project macros. Can someone help me to
do the following:
1. How do I schedule my macro to run at 3:00 AM? Do I need to have a VB6
program launch MS Project and run the macro?
2. I need to open this master project plan with Write access to all the
plans and so how do I open the Password protected files (I can hardcode the
password, and I'm fine doing that).
3. How do I Save the files (and how do I Not save a file if it's already
opened)?
Thanks in advance for your help.
plans are password protected.
I work in the PMO and I have a working macro that I manually run at night,
which scans the various plans and performs a series of quality checks (error
checks) and updates Text1 with notes for the project managers to clean things
up. They really like the tool, but I want to go home earlier and since I
need Write access, I really need to be scheduling this at 3:00 AM.
I know how to program if VB6 and MS Project macros. Can someone help me to
do the following:
1. How do I schedule my macro to run at 3:00 AM? Do I need to have a VB6
program launch MS Project and run the macro?
2. I need to open this master project plan with Write access to all the
plans and so how do I open the Password protected files (I can hardcode the
password, and I'm fine doing that).
3. How do I Save the files (and how do I Not save a file if it's already
opened)?
Thanks in advance for your help.