Important file overwritten

  • Thread starter Thread starter Neville
  • Start date Start date
N

Neville

I have accidentally overwritten a large and important
workbook. Is there any way I can retrive it? I run Excel
97 and Windows XP I have not closed Excel or shut down my
computer since.
Hope someone can help
Neville
 
This may help for the future

Sub Backup() 'kept in personal.xls & assigned to toolbar button
On Error GoTo BackupFile
MkDir CurDir & "\Backup"
BackupFile:
With ActiveWorkbook
MyWB = .Path & "\BACKUP\" & .Name
.SaveCopyAs MyWB
.Save
End With
End Sub
 
In addition, this will make sure that all your new workbooks
automatically create a backup whenever they are saved:

Create a blank book with the formatting, number of sheets, etc.,
that you want. Save it as a template in the XLStart folder with the
name "Book.xlt". In the Save dialog, click Options and check the
Always create backup checkbox, then click OK.
 
Back
Top