Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
This code: Sub SaveBackup() ActiveWorkbook.SaveCopyAs "D:\My Book.xls" End Sub works great to save a back up copy of My Book but I need to change it in this way : I need first to delete My Book which is on drive D: before to replace it with the new one. I need to have a copy of My Book in my Recycle Bin because some times the new My Book which replaces My Book on drive D: has errors on it and thats why I need to have a copy of the old My Book in the Recycle Bin before the replacement. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
closed workbook macro | Excel Discussion (Misc queries) | |||
How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
Executing a macro in a closed workbook | Excel Programming | |||
macro to change the names and delete closed books | Excel Discussion (Misc queries) | |||
Run a Macro over a Closed Workbook?? | Excel Programming |