Multiple Versions

A

Andrew

Can Excel save multiple versions of a file automatically (as opposed to using
Save --> As)?
 
D

Dana DeLouis

...as opposed to using Save --> As)?

Just throwing out an idea that I use. If you wish, you could run a macro
that makes a Copy of your workbook using the "SaveCopyAs" command. The
advantage of using this command is that it does not change the name of your
current workbook. You can get pretty fancy if you wish. For example, your
macro could prompt for Document properties just prior to saving a copy.
When developing a Workbook, you could have the macro automatically save a
new version every x number of minutes in a special folder. Again... lots of
ideas along this line. Here's a very basic idea. This keeps the same file
name, but adds a date/time stamp to the end of the file name.

Sub Demo()
'// Location of Backup
Const Backup As String = "C:\Backup_Excel\"
Dim s As String
Dim v As Variant

With ActiveWorkbook
' Your own format idea here...
s = Format(Now, " {mmm dd yyyy @ hh\h mm\m ss\s}")

v = Split(.Name, ".")
v(0) = Backup & v(0) & s
.SaveCopyAs Join(v, ".")
End With
End Sub

For ideas on Document properties, see Chip's excellent web site at:
http://www.cpearson.com/excel/docprop.htm

Not exactly what you wanted, but one can also track changes to a workbook.
Tools | Track Changes...
 
Top