Save a BackUp of Workbook
 

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?

--
Regards,
Rocky McKinley

Save a BackUp of Workbook
 

Rocky,

Something like:

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

Robin Hammond
www.enhanceddatasystems.com

"Rocky McKinley" wrote in message
...
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?

--
Regards,
Rocky McKinley