Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can you save a spreadsheet with a date stamp.
I need to save a file 2 times the first time for production, the second time
as a backup, I want the backup file to have a date stamp (ex. gltransfer051506.csv). i need the date to update each day it run.??? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can you save a spreadsheet with a date stamp.
This macro may do what you wish, it also adds the TIME......
Sub AddDateToFilename() Dim Dname As String Dname = ThisWorkbook.FullName Dname = Left(Dname, Len(Dname) - 4) & _ Format(Now, "yyyymmdd_hh_mm_ss") & ".xls" ThisWorkbook.SaveCopyAs Dname End Sub Vaya con Dios, Chuck, CABGx3 "kenny" wrote: I need to save a file 2 times the first time for production, the second time as a backup, I want the backup file to have a date stamp (ex. gltransfer051506.csv). i need the date to update each day it run.??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
save a spreadsheet file with same name but different version | New Users to Excel | |||
Need to insert file modified date of Excel spreadsheet in a cell | Excel Discussion (Misc queries) | |||
Insert Automatic, Non-Updating Date Stamp | Excel Discussion (Misc queries) | |||
My hyperlink in an excel spreadsheet will not save. | Excel Discussion (Misc queries) | |||
How to save an excel spreadsheet as a text file without added quot | Excel Discussion (Misc queries) |