Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatic recovery info
I just accidentally closed out the wrong file of two files without saving
and then, foolishly further, re-opened it in the hopes that I had saved it. I did not. I assume that any automatic recovery saves I did are lost forever right? Thanks! Dean, the idiot! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatic recovery info
Dean
Autorecover offers the chance to recover from a crash, not user fat fingers. The temporary Autorecovery files are deleted when/if the workbook is successfully saved/closed, which was the case in your situation. So.......yes, you are right. No do-overs. Some info for your perusal and possible assistance in future. If you're using Excel 2002 or 2003, there is no Autosave in XL2002 and 2003 as there was in earlier versions. Autorecovery from ToolsOptionsSave is it. This is not the same as Autosave which made true incremental saves at intervals and alerted you before saving. Autorecovery just saves a temporary file which it deletes if Excel closes normally without incident. BTW.....Dave Peterson reports that he tried an earlier version of Autosave.xla in XL2002 and it seemed to work fine. I have also tried the Autosave.XLA from XL97 on 2002 and 2003 and does the job. To download the 97 version go here..... http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm In addition to the above......Jan Karel Pieterse has an addin called AutoSafe which also doen't alert before saving. It doesn't overwrite the existing workbook when it saves. It saves to a user selectable folder. And when it's done, it either deletes these backups (or puts them in the recycle bin). And the user can always restore the backups from the recycle bin. http://www.jkp-ads.com/Download.htm (look for AutoSafe.zip) Gord Dibben MS Excel MVP On Sat, 3 Mar 2007 15:02:14 -0800, "Dean" wrote: I just accidentally closed out the wrong file of two files without saving and then, foolishly further, re-opened it in the hopes that I had saved it. I did not. I assume that any automatic recovery saves I did are lost forever right? Thanks! Dean, the idiot! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatic recovery info
Dean,
Auto-recovery is not auto-save. It saves information needed to restore a corrupted workbook, not a complete copy of your workbook. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Dean" wrote in message ... I just accidentally closed out the wrong file of two files without saving and then, foolishly further, re-opened it in the hopes that I had saved it. I did not. I assume that any automatic recovery saves I did are lost forever right? Thanks! Dean, the idiot! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatic recovery info
Thanks all!
"Chip Pearson" wrote in message ... Dean, Auto-recovery is not auto-save. It saves information needed to restore a corrupted workbook, not a complete copy of your workbook. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Dean" wrote in message ... I just accidentally closed out the wrong file of two files without saving and then, foolishly further, re-opened it in the hopes that I had saved it. I did not. I assume that any automatic recovery saves I did are lost forever right? Thanks! Dean, the idiot! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatic recovery info
Here's a neat little snippet from Mr. Guillett that I have used for a long
time now. It's kind of like an itch, you learn to scratch it without really thinking about it. Sub backup() 'Don Guillett, misc, 2000-05-08 Fname = ActiveWorkbook.Name ActiveWorkbook.SaveCopyAs "C:\msoffice\personal\BACKUP\ " & Fname ActiveWorkbook.Save End Sub Regards, Alan "Dean" wrote in message ... I just accidentally closed out the wrong file of two files without saving and then, foolishly further, re-opened it in the hopes that I had saved it. I did not. I assume that any automatic recovery saves I did are lost forever right? Thanks! Dean, the idiot! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatic recovery info
What is the advantage of this over just clicking the save icon every so
often - I don't get it. Are you assuming that I have a reason, other than laziness, not to save it under the same filename? I don't. Thanks, Alan! Dean "Alan" wrote in message ... Here's a neat little snippet from Mr. Guillett that I have used for a long time now. It's kind of like an itch, you learn to scratch it without really thinking about it. Sub backup() 'Don Guillett, misc, 2000-05-08 Fname = ActiveWorkbook.Name ActiveWorkbook.SaveCopyAs "C:\msoffice\personal\BACKUP\ " & Fname ActiveWorkbook.Save End Sub Regards, Alan "Dean" wrote in message ... I just accidentally closed out the wrong file of two files without saving and then, foolishly further, re-opened it in the hopes that I had saved it. I did not. I assume that any automatic recovery saves I did are lost forever right? Thanks! Dean, the idiot! |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatic recovery info
I didn't mean anything about anything Dean! I just threw an idea out there.
If you look closely, it doesn't just save, like you're clicking the save icon, it saves a backup. I use this as I am coding so I can go back if I want. Geeez, some people are so freakin' touchy! "Dean" wrote in message ... What is the advantage of this over just clicking the save icon every so often - I don't get it. Are you assuming that I have a reason, other than laziness, not to save it under the same filename? I don't. Thanks, Alan! Dean "Alan" wrote in message ... Here's a neat little snippet from Mr. Guillett that I have used for a long time now. It's kind of like an itch, you learn to scratch it without really thinking about it. Sub backup() 'Don Guillett, misc, 2000-05-08 Fname = ActiveWorkbook.Name ActiveWorkbook.SaveCopyAs "C:\msoffice\personal\BACKUP\ " & Fname ActiveWorkbook.Save End Sub Regards, Alan "Dean" wrote in message ... I just accidentally closed out the wrong file of two files without saving and then, foolishly further, re-opened it in the hopes that I had saved it. I did not. I assume that any automatic recovery saves I did are lost forever right? Thanks! Dean, the idiot! |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatic recovery info
One of the hazards of this medium is people can't see your expression when
you wrote the words. I meant no offense whatsoever. I appreciate your attempt at helping. When I do save, I usually, rename the file as -1, -2, -3 so I can go back as well, although it's usually more so that if a file corrupts, I might have a version that I can reprogram. Best regards, Dean "Alan" wrote in message ... I didn't mean anything about anything Dean! I just threw an idea out there. If you look closely, it doesn't just save, like you're clicking the save icon, it saves a backup. I use this as I am coding so I can go back if I want. Geeez, some people are so freakin' touchy! "Dean" wrote in message ... What is the advantage of this over just clicking the save icon every so often - I don't get it. Are you assuming that I have a reason, other than laziness, not to save it under the same filename? I don't. Thanks, Alan! Dean "Alan" wrote in message ... Here's a neat little snippet from Mr. Guillett that I have used for a long time now. It's kind of like an itch, you learn to scratch it without really thinking about it. Sub backup() 'Don Guillett, misc, 2000-05-08 Fname = ActiveWorkbook.Name ActiveWorkbook.SaveCopyAs "C:\msoffice\personal\BACKUP\ " & Fname ActiveWorkbook.Save End Sub Regards, Alan "Dean" wrote in message ... I just accidentally closed out the wrong file of two files without saving and then, foolishly further, re-opened it in the hopes that I had saved it. I did not. I assume that any automatic recovery saves I did are lost forever right? Thanks! Dean, the idiot! |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatic recovery info
Yes, there are hazards to using this medium, so please try not to assume
about people assumptions. As far as I can tell, everyone is here just trying to help others. Take it for what it is and don't assume anything other than someone is trying to help. Otherwise, easy is assumed as lazy. Where the heck did that come from? And, Thanks, Alan! will not be taken as it was projected. No response is necessary or even wanted. "Dean" wrote in message ... One of the hazards of this medium is people can't see your expression when you wrote the words. I meant no offense whatsoever. I appreciate your attempt at helping. When I do save, I usually, rename the file as -1, -2, -3 so I can go back as well, although it's usually more so that if a file corrupts, I might have a version that I can reprogram. Best regards, Dean "Alan" wrote in message ... I didn't mean anything about anything Dean! I just threw an idea out there. If you look closely, it doesn't just save, like you're clicking the save icon, it saves a backup. I use this as I am coding so I can go back if I want. Geeez, some people are so freakin' touchy! "Dean" wrote in message ... What is the advantage of this over just clicking the save icon every so often - I don't get it. Are you assuming that I have a reason, other than laziness, not to save it under the same filename? I don't. Thanks, Alan! Dean "Alan" wrote in message ... Here's a neat little snippet from Mr. Guillett that I have used for a long time now. It's kind of like an itch, you learn to scratch it without really thinking about it. Sub backup() 'Don Guillett, misc, 2000-05-08 Fname = ActiveWorkbook.Name ActiveWorkbook.SaveCopyAs "C:\msoffice\personal\BACKUP\ " & Fname ActiveWorkbook.Save End Sub Regards, Alan "Dean" wrote in message ... I just accidentally closed out the wrong file of two files without saving and then, foolishly further, re-opened it in the hopes that I had saved it. I did not. I assume that any automatic recovery saves I did are lost forever right? Thanks! Dean, the idiot! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto recovery | Excel Discussion (Misc queries) | |||
Automatic moving cell Info | Excel Worksheet Functions | |||
excel, automatic date and time when info gets entered | Excel Worksheet Functions | |||
document recovery | New Users to Excel | |||
How do I set interval for automatic save? (not auto recovery) | Excel Discussion (Misc queries) |