macro to delete a closed workbook
- From: Tim <Tim@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 29 Jun 2005 22:51:01 -0700
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.
.
- Follow-Ups:
- Re: macro to delete a closed workbook
- From: Nick Hodge
- Re: macro to delete a closed workbook
- Prev by Date: How To enable the Sort function for a protected Excel ***
- Next by Date: Re: Automatic Saving as Web Page
- Previous by thread: How To enable the Sort function for a protected Excel ***
- Next by thread: Re: macro to delete a closed workbook
- Index(es):