Multiple Versions
 

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

No, Excel doesn't have a version feature similar to the one in Word.

Andrew wrote:
Can Excel save multiple versions of a file automatically (as opposed to using
Save -- As)?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

...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...

--
Dana DeLouis
Win XP & Office 2003


"Andrew" wrote in message
...
Can Excel save multiple versions of a file automatically (as opposed to
using
Save -- As)?

You may want to check Jan Karel Pieterse's AutoSafe add-in
(http://www.oaltd.co.uk/MVP/Default.htm and scroll down about a page
and a half).

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Can Excel save multiple versions of a file automatically (as opposed to using
Save -- As)?