Force save with timestamp

[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.

 

[Guest]

Use the beforeclose event.

http://www.cpearson.com/excel/events.htm

 

[Vasant Nanavati]

In the ThisWorkbook module:

Private Sub Workbook_BeforeClose()
Me.Save
End Sub

The file will bear the new timestamp.
____________________________________________________________________________