#1   Report Post  
Posted to microsoft.public.excel.misc
Dana DeLouis
 
Posts: n/a
Default Saving Versions

Hi. Here's a general workaround that I use.
I have a toolbar button that runs code similar to the following. The idea
here is that vba has a "SaveCopyAs" command. What this does is saves a copy
of your workbook under a different name, but leaves the original workbook
name unchanged.
There are 100's of ways to write this. This is just a general idea.
This saves your workbook using the original name, but to make it different,
appends the date to the file name.
Hope there are some ideas here that you can use.

Sub SaveCopyOfFile()
Dim s As String
Const FileLocation As String = "C:\UnderDevelopment\"

s = FileLocation & ActiveWorkbook.Name
s = s & Space(1) & Format(Now, "yyyy mm dd Hh Nn Ss")
s = s & ".xls"

ActiveWorkbook.SaveCopyAs s
End Sub

--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"Bruce" wrote in message
...
I'm probably confused or didn't ask the question correctly.

In Word, if I click File, and Versions..., I can save version 1, version
2,
version 3, etc. of the same document. I don't have to append the name
with a
"v2" or anything, as in a "Save As".

I'm not trying to save Excel 2003 files as another version of Excel. I'm
just trying to keep a history for roll-back purposes of a single document.

"Bearacade" wrote:


It's under File - Save As - Save As Type:


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile:
http://www.excelforum.com/member.php...o&userid=35016
View this thread:
http://www.excelforum.com/showthread...hreadid=552718




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving worksheet as webpage Aramis Excel Discussion (Misc queries) 1 January 9th 06 10:26 PM
Saving worksheet so that merge cells work in previous versions jimmylightning Excel Worksheet Functions 1 December 25th 05 01:58 PM
How do I stop Excel 2000 from saving file history from file that . Cathy Excel Discussion (Misc queries) 0 March 29th 05 03:27 PM
Saving Bond Wizard. Old Versions I Could Copy the data sbwizard Excel Discussion (Misc queries) 1 January 4th 05 02:18 AM
Error Message appearing when saving a file JaneC Excel Discussion (Misc queries) 0 November 25th 04 10:35 PM


All times are GMT +1. The time now is 04:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"