|
Posted to microsoft.public.excel.programming
|
|
|
Recover modules and forms from a damaged spreadsheet.
Time to make backups!
Pred wrote:
I'll have a look at OpenOffice.org.
Thanks Dave.
By the way, my file got restored and it took me about 45 minutes to redo my
today's work. Less painfulf than I thought!
"Dave Peterson" wrote:
You may want to try OpenOffice.org and try opening, then saving (as a new
name). It's been known to save some (not always all) data, formatting, formulas
and code.
http://www.openoffice.org, a 60-65 meg download or a CD
If the file is really important, there are commercial recovery services. I've
never used it, but you might want to check into:
http://www.officerecovery.com
Pred wrote:
One of my spreadsheet got corrupted today. I don't know why.
So much corrupted that Excel had to "Repair" it when I tried to re-open the
file. Unfortunately I have made several changes to my VBA code between and I
just "Save" the file. I know! I should have done a "Save as".
When Excel "Repairs" a file, it looks at spreadsheet data only. So I have
lost all my VBA code.
Is there a way to recover the VBA code as well?
My only alternative for now is to restore the file from yesterday's backup
and redo my VBA code.
René
--
Dave Peterson
--
Dave Peterson
|