Force save with timestamp

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a way to force excel to save the workbook after the user closes the
workbook. When it saves, I need it to save a timestamp to the original file
name.
 
In the ThisWorkbook module:

Private Sub Workbook_BeforeClose()
Me.Save
End Sub

The file will bear the new timestamp.
____________________________________________________________________________
 
Back
Top