I am trying to save an mpp project file as a project database file via vba code in an access module.
It doesn't like the formatID "MSProject.mpd" even though I took it directly from the help file. Does anyone know how to make this work.
The end goal is to open a series of project files in a folder and save each of them to the same project database file. Then I would have 1 file with all the data to query from.
Below is the line that errors. I know that it is the format ID because if I change the formatid to something else it runs fine.
prjApp.FileSaveAs "\\CHIL-DATA1\SHARE\Information Services\IS Planning\Delivery Support Tool\test\projectdb\Test", FormatID:="MSProject.mpd"
THanks in avdvance for any help!
It doesn't like the formatID "MSProject.mpd" even though I took it directly from the help file. Does anyone know how to make this work.
The end goal is to open a series of project files in a folder and save each of them to the same project database file. Then I would have 1 file with all the data to query from.
Below is the line that errors. I know that it is the format ID because if I change the formatid to something else it runs fine.
prjApp.FileSaveAs "\\CHIL-DATA1\SHARE\Information Services\IS Planning\Delivery Support Tool\test\projectdb\Test", FormatID:="MSProject.mpd"
THanks in avdvance for any help!