FileSaveAs and EPM Custom Fields

[CARIFIN]

I'm trying to write a macro that saves a project on Project Server
2007 to the local hard drive while saving all of the EPM Custom
Fields. I'm using the code below and it works fairly well- but when
you open the file in local mode, the EPM fields do not show.

FileSaveAs Name:=FilePath, FormatID:="MSProject.MPP"

Does anyone know how to do a file save while keeping the EPM local
fields when saving to the desktop?

 

[Jack Dahlgren MVP]

I don't think the problem is with your code.
To show the enterprise fields when working with an MPP file, do the
following:
Go to tools menu / Enterprise Options / Microsoft Office Project Server
Accounts
Make sure the "Manual control connection state" option is checked.
Shut down project.
Restart project.
When the connection dialog box appears, select the EPM project server
connection (not "Computer").
Click the "Work Offline" button.
Now open the project file.

-Jack Dahlgren

 

[CARIFIN]

Jack-

Thanks for that excellent advice.

Currently I have a macro that runs in a master project and saves all
the subprojects inside a folder. This folder is then being sent to a
3rd party independent auditor/contractor for analysis. They
unfortunately wont be able to have access to our servers and therefore
wont be able to have a cached version of the enterprise fields.

I know that when you do a save as when your connected to the server,
there is an option to save your file with all of the enterprise
fields. I was wondering if there was any codes/flags that can utilize
this functionality. Thanks!

Chris

 

[CARIFIN]

Jack-

Thanks for that excellent advice.

Currently I have a macro that runs in a master project and saves all
the subprojects inside a folder. This folder is then being sent to a
3rd party independent auditor/contractor for analysis. They
unfortunately wont be able to have access to our servers and therefore
wont be able to have a cached version of the enterprise fields.

I know that when you do a save as when your connected to the server,
there is an option to save your file with all of the enterprise
fields. I was wondering if there was any codes/flags that can utilize
this functionality. Thanks!

Chris

 

[CARIFIN]

Jack-

Thanks for that excellent advice.

Currently I have a macro that runs in a master project and saves all
the subprojects inside a folder. This folder is then being sent to a
3rd party independent auditor/contractor for analysis. They
unfortunately wont be able to have access to our servers and therefore
wont be able to have a cached version of the enterprise fields.

I know that when you do a save as when your connected to the server,
there is an option to save your file with all of the enterprise
fields. I was wondering if there was any codes/flags that can utilize
this functionality. Thanks!

Chris