Results 1 to 2 of 2
2007-04-20, 10:54 #1
- Join Date
- Jul 2001
- Terneuzen, Netherlands
- Thanked 0 Times in 0 Posts
Backup before save (MS Project 2003)
I want to have an automatic backup of my MSProject file when I save a new version. So I created this code in the "Project_BeforeSave" sub:
FilePath = Filename & DateTime & ".mpp"
Application.EnableEvents = False
Application.EnableEvents = True
Of course I needed to disable the events as the "SaveAs" would fire this sub again. To my surprise, that doesn't work in Project like this (I do this often in Excel but am new to Project).
How do I save a copy of the file (with another name) when I choose to save the original?
2007-04-20, 12:06 #2
- Join Date
- Mar 2002
- Thanked 28 Times in 28 Posts
Re: Backup before save (MS Project 2003)
I don't have an answer for you (I don't use MS Project), but you should be aware that each Office application is developed by a different team (and the original application may have been developed outside Microsoft), so VBA doesn't work the same way in all of them.
See Application Object for an overview of available properties, methods and events.