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.
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
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
