macro to delete a closed workbook
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.
|