Save a BackUp of Workbook

[Rocky McKinley]

I would like to save a back up copy of the current workbook everytime it is
saved. I would like to use the BeforeSave event. How do I acheive this
without altering the normal save path?

 

[Robin Hammond]

Rocky,

Something like:

Sub SaveBackup()
ActiveWorkbook.SaveCopyAs "c:\temp\backup.xls"
End Sub

Robin Hammond
www.enhanceddatasystems.com