I have a spreadsheet that when opened normally from Excel complains
about an error of an invalid sheet name. It opens fine after renaming it.
My automation code does not have such luck. With the default setting for
corruptLoad it fails with an Unknown error, and the same results if I
pass xlRepairFile for the CorruptLoad parameter.
I was able to write a
VB macro that opened the file just fine using
corruptLoad.
Has anybody used that successfully from C++?
TIA
JO