View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Tim is offline
external usenet poster
 
Posts: 408
Default 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.