Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto save file copy with unique filename
Several users access an Excel file. I need Excel to save a copy of the file
with a unique filename when it saves the original file under the original name. -- Allen |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto save file copy with unique filename
Hi Allen
You can use the before save event in the thisworkbook module to save a copy of the file with a date/time stamp Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) ThisWorkbook.SaveCopyAs ThisWorkbook.Name _ & " " & Format(Now, "dd-mmm-yy h-mm-ss") & ".xls" End Sub See http://www.cpearson.com/excel/events.htm -- Regards Ron De Bruin http://www.rondebruin.nl "Allen" wrote in message ... Several users access an Excel file. I need Excel to save a copy of the file with a unique filename when it saves the original file under the original name. -- Allen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Save File (Unique file name) | Excel Worksheet Functions | |||
Additional file with no extension created during File Save As proc | Excel Discussion (Misc queries) | |||
Excel XP: File name in Title Bar not changed after Save As... | Excel Discussion (Misc queries) | |||
How do I "auto save" my file in MsOffice2003 Exel? | Charts and Charting in Excel | |||
Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) |