Avoiding save changes dialog box

S

Scott Sanders USA

Hi,
I have a Portfolio project that I'm opening and saving a copy to a
fileserver. When i do a FileSaveAs i get message boxes for the sub-projects
asking if I want to save them.
I know on FileClose you can specify PjSaveType.pjDoNotSave. Can you do the
same type of thing for FileSaveAs?
Thanks.
Scott
 
J

John

Scott Sanders USA said:
Hi,
I have a Portfolio project that I'm opening and saving a copy to a
fileserver. When i do a FileSaveAs i get message boxes for the sub-projects
asking if I want to save them.
I know on FileClose you can specify PjSaveType.pjDoNotSave. Can you do the
same type of thing for FileSaveAs?
Thanks.
Scott

Scott,
Add the following line to your code:
DisplayAlerts = False

Hope this helps.
John
Project MVP
 
S

Scott Sanders USA

When i put that line in, project is unable to find the enterprise project
files. It seems like that line breaks my connection to project server. I
need to reset my project server account to point to the server. Strange
behavior. Any ideas why??
Thanks!
Scott
 
J

John

Scott Sanders USA said:
When i put that line in, project is unable to find the enterprise project
files. It seems like that line breaks my connection to project server. I
need to reset my project server account to point to the server. Strange
behavior. Any ideas why??
Thanks!
Scott

Scott,
Sorry, I don't do Server. If I had to guess, and that's all it would be,
is that the placement of the DisplayAlerts code in your macro is
critical. Try putting it right before the FileSaveAs and then setting it
back to true after the save is completed.

John
 
R

Rod Gill

Firstly don't save master projects in Project Server, grief and duplicate
data awaits those who do!

Second, don't ever mess with master files. Only save as if all sub-projects
are also open and you save ALLLLLLL the sub-projects as well. Failure to do
so will lead to corruption of one or more projects sooner or later. Any file
can only be linked to one master file at a time. Copies of master files
cause chaos and often corruption.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com
 
S

Scott Sanders USA

Thanks for that info Rod. How about if I break the links to the subprojects,
then save the master project (as static) to a file server. Hopefully this
way, there will be no contention, or ability to mess with the project server
data. does that sound safe to you??
Thanks again.
Scott
 
R

Rod Gill

Absolutely. In fact I always create master files with the link option off so
I only copy data (and consolidate resource info automatically) and create a
weekly snapshot.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top