You may want to try OpenOffice.

A few people have said that OpenOffice.Org has been able to open the file. Then
they clean it up and save it there. Then excel can open that cleaned up
version.

http://www.openoffice.org, a 60-104 meg download or a CD

I tried it a few months ago and IIRC, the VBA code was commented out (with
REM's???). But at least I could get to the code.

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

G Lykos wrote:

Ouch. Contains (should I say contained?) a library of assorted home-grown
utilities, and I made recent changes to it that aren't backed up.

Fixing the workbook removes the VBA section.

I can open the corrupted workbook file with Word, as suggested by others,
but the macro libraries appear a mishmash of text and special characters. I
tried the same on a good workbook with the same results, so have not given
up hope that the libraries are for the most part still readable.

The question, then: anyone know of a viewer that can be used on a corrupted
.XLS file to see native VBA modules displayed in readable format ? I'd be
more than pleased just to be able to hunt for and copy snatches of module
code in text format, to be pasted into a new workbook.

Thanks for any ideas!
George

--

Dave Peterson