Creating a backup copy

[Steve]

Hi, i need to create a backup copy of a project. The project i want to backup
is stored in a Access DB and i want to create a .mpp-file to use as a backup.
I tried using FileSaveAs (CurPrj.SaveAs "c:\Temp2", pjMPP) to create the copy
but then i have to do another FileSaveAs (CurPrj.SaveAs
"<c:\MyDb.mdb>\test", pjMPP, False, False, False, False, False, "", "",
"MSProject.MDB8" ) to restore the project so its saved to the correct path
but then i get a msgbox asking the "the project exist do you want to
overwrite" etc. Is there a better way to do this???

 

[Earl Lewis]

Why are you doing the 2nd save? Are changes being made to the plan at the same time that you want saved too? If so, what you're doing is pretty reasonable. You could control this through a user form that asks if the user wants to save back to the database too and if not you could skip that step.

What do you want to see happen?

Earl


Hi, i need to create a backup copy of a project. The project i want to backup
is stored in a Access DB and i want to create a .mpp-file to use as a backup.
I tried using FileSaveAs (CurPrj.SaveAs "c:\Temp2", pjMPP) to create the copy
but then i have to do another FileSaveAs (CurPrj.SaveAs
"<c:\MyDb.mdb>\test", pjMPP, False, False, False, False, False, "", "",
"MSProject.MDB8" ) to restore the project so its saved to the correct path
but then i get a msgbox asking the "the project exist do you want to
overwrite" etc. Is there a better way to do this???