automatically save a copy of the workbook when saving or closing it

[excel1]

Hi,

In the case of somebody saving or closing a document (ActiveWorkbook.Save or ActiveWorkbook.Close or ActiveWorkbook.SaveAs) I would like to create another copy of the workbook in a specific location (harcoded in the macro) named as the original file but with the timestamp as ending (i.e. name_timestamp.xls).

Can anybody help me?

Thanks in advance

[chergh]

use the 'savecopyas' method of the workbook

Please Login or Register  to view this content.

[excel1]

thanks for the answer, but how do I trigger the script when there is a save, save as or a close? I want to make a copy of the file in any of those cases.

[chergh]

Use the workbook events, in the VB editor select workbook from the left hand drop down menu near the top of the window and choose the beforesave and beforeclose events from the right hand drop down menu.

[excel1]

Thank you so much for the answer. It did work perfectly