LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
closed workbook macro puiuluipui Excel Discussion (Misc queries) 1 July 4th 08 10:13 PM
How to Delete a Range in Closed Workbook (to Replace Delete Query) [email protected] Excel Discussion (Misc queries) 1 March 8th 06 10:10 AM
Executing a macro in a closed workbook Alex Excel Programming 0 June 20th 05 03:35 PM
macro to change the names and delete closed books Tim Excel Discussion (Misc queries) 2 February 6th 05 09:39 PM
Run a Macro over a Closed Workbook?? John[_78_] Excel Programming 8 February 25th 04 02:28 PM


All times are GMT +1. The time now is 08:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"