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

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" <fsilga2001@yahoo.com> wrote in message news:67D03186-F407-43B2-B5B8-0642DD5593B5@microsoft.com...
> 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