Version Identification

ExecEd

New Member
Joined
Apr 21, 2002
Messages
31
With minute variations and edits from version to version, keeping soft and hard copies of generations of spreadsheets can be challenging.

I already name the files as FILE20020429 but are their other ways to track versions?

Thanks for any brainstorming you can provide!
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
include the time in the filename ?

thusly YYYYMMDDHHMM.xls

I'm sure the VBA guys could ship up somethign that does this at the touch of a button

:)


edit........ typo : I meant "whip up something"
This message was edited by Chris Davison on 2002-04-29 13:42
 
Upvote 0
Following Chris' suggestion, use the following as the Filename in your SaveAs code.

Format(Now, "YYYYMMDDHHMM") & ".xls"

The .xls may not be necessary, so give this a try with and without that part.

Bye,
Jay
 
Upvote 0
Hi,

1. Copy the routine posted below

2. Right click on the Excel icon at the top of the window, next to the File option in the worksheet menu bar

3. Choose View Code

4. Paste the copied routine

'----------------
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

Dim StrNameFile As String
StrNameFile = "FILE" & Format(Now, "YYYYMMDDHHMM") & ".xls"
ThisWorkbook.SaveAs FileName:=StrNameFile

End Sub
'---------------

Whenever you click the save button, this will save the workbook with the file name/date/time.

Bye,
Jay
 
Upvote 0
By the way, this worked and I've incorporated the code in several macros I've created since.

Thanks.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,202
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top