Hi Frank,

I am sorry for delay response.

It seems that we can also reproduce the problem by manually opening the
file on Excel 2003
1) Start Excel 2003.
2) Click File, Open and browse to the "ExcelOpen-xlRepairFileFailure.xls"
file.
3) Click the Open dropdown button and select "Open and Repair¡*"
4) Select the Repair option.
Result:

"Errors were detected in 'ExcelOpen-xlRepairFileFailure.xls', but Microsoft
Office Excel was able to open the file by making the repairs below..
Excel then reports:
"Damage to the file was so extensive that repairs were *not* possible.
Excel attempted to recover your formulas and values, but some data may have
been lost or corrupted."

Since the workbook cannot be repaired by Excel, you will get the run-time
error when you pass in the repair option to the Open method. This allows a
developer that is automating Excel to detect (by trapping the error) when a
workbook is corrupt and cannot be automatically repaired by Excel. By
Excel raising the error, the developer is allowed to trap for the error and
alert the user that this xls file is damaged and cannot be recovered. If
Excel did not raise an error in this case, the developer would not have
confidence that the workbook was opened/repaired successfully.

Did the problem persists with all your Excel 95 file with chart?

I have made a test that I was able to successfully repair a simple xl95
workbook with a chart. So I think there is something more specific to your
workbook that is causing the error.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.