Project 2007: FileSaveAs and automated overwriting

[Makkan]

I want to automate project to copy the active project.
I dont want any dialog boxes to appear during this copy process.
I CANNOT delete an existing copy because this would disrupt my lookup in the
background.

FileSaveAs method prompts to overwrite the target project if it already
exists. If I set DisplayAlerts to FALSE this method returns false and does
not save the project.
SaveAs method throws an unexpected method error exception if the target
project exists and DisplayAlerts is also set to FALSE and prompts the user
too If set to TRUE.

Any help is appreciated. Thank you very much!

 

[Jan De Messemaeker]

Hi,


if len(vba.dir(theaddress))>0 then
vba.kill TheAddress
end if
filesaveas Theaddress

Hope this helps,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Makkan]

Hi,

thank you Jan but this is not a solution as I mentioned before.
I must not delete the project under any circumstances.

To add something: The copied projects exist in Project Server and can be
published. That is why I cannot delete them.

 

[Jan De Messemaeker]

Hi,

Sorry, should haev read your message more carefully.
If it's Enter you have to type you can try putting the following statement
before the saveas statement:
VBA.Sendkeys "~"
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf