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 that’s why I need to have a copy of the old “My Book”
in the Recycle Bin before the replacement.

.