Thread: Import VBA Code
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Import VBA Code

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