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.

Use the beforeclose event.

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



--
Regards,
Tom Ogilvy


"Ryan" wrote:

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.
__________________________________________________ __________________________

"Ryan" wrote in message
...
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.