Import VBA Code
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 |
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 |
Import VBA Code
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. -----Original Message----- 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 . |
All times are GMT +1. The time now is 03:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com