If you knew the structure of a compound document file and the biff encoding
for the excel portions of that file, you could probably write thousands of
lines of code to read the file and perhaps work around the "corruption".
Easier might be to fine someone who has xl2002 and see if they can open a
copy of the file (xl2002 has a built in repair facility)
Or download the free OpenOffice software that can read xl files and doesn't
appear to respect a lot of the "corruptness" that excel does (from what I
have seen posted here
From Harald Staff:
Good old StarOffice, now known as OpenOffice
http://www.openoffice.org/
is known to open and recover corrupt Excel and Word files.
Now don't you dare to complain about the size of the download....
Best wishes Harald
-------------------------
Regards,
Tom Ogilvy
"Joe Zamboni" wrote in message
...
I have what I believe to be a corrupt Excel file that I am
unable to open. I would like to know if I can write code
in a new workbook that would copy or import the code from
the corrupt file to the new workbook. Is this possible
with VBA?
Thank you for your consideration.
Sincerely,
Joe Zamboni