Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import XML data...Is there a size limit on the import? | Excel Discussion (Misc queries) | |||
How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
Code to import from txt to excel | Excel Discussion (Misc queries) | |||
Trying to write vba code to import another spreadsheet... | Excel Discussion (Misc queries) | |||
Import a Code to a paragraph using a formula or macro! | Excel Worksheet Functions |