| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| always save backup | Setting up and Configuration of Excel | |||
| auto save a backup copy of a workbook | Excel Discussion (Misc queries) | |||
| Where does Save As Automatic Backup save its files? | Excel Discussion (Misc queries) | |||
| workbook creates a backup evertime I save it. how to remove? | Excel Worksheet Functions | |||
| Why don't my latest changes get save in my backup | Excel Worksheet Functions | |||
Linear Mode
