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