Import VBA Code

[Joe Zamboni]

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

 

[Tom Ogilvy]

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

 

[Joe Zamboni]

Thanks, Tom. I'll find someone with XL2002 and give it a
try. It will open in OpenOffice, but it removes much of
the formatting, range names, etc. That presents problems
of its own, since there is tons of formatting and named
ranges. Thanks again.