Error HRESULT Excel opening

hi robert!

i have done many imports with this tool by now and i strangly get the error that i joined as attachment, whatever the excel i try to open.

i used to have office 2007. here's the thing i tried to deal with this in order.

- delete registry current_user_key for excel
- repair my office 2007
- reinstall office 2007
- install office 2003
- reinstall flowheater

still get the problem, i tought it might be the path that contains > 255 caracs, but wasn't this too.

do you have any idea ?? it was working well and i'm not sure about what i've done to get now this error.

thanks !

Hi Francis,

Please have a look to the two links below. I think this workaround will solve your problem.

Bug fixed: Excel Adapter and variant MS Excel language versions!

Issue opening excel file

hi robert ! the key i put into my register make this works well !

but by now i'm expecting a problem probably because of this with forfiles command

i used this function a lot in the past : here's what i do

i have 3 files :

type-1-1.xls
type-1-2.xls
type-1-3.xls

other files are like type-2 etc..

so i'm doing this command

forfiles /m type-1-*.xls /c "cmd /c ..\..\..\..\..\bin\fhbatch.exe /readfilename @path 2-link-tblensembleunepiece-type-1.fhd"

the first one work, the 2 others, "invalid bad index" like the screen shot

Please try to import the second excel file manually like

FHBatch.exe /ReadFileName Type-1-2.xls 2-Link-tblensembleunepiece-Type-1.fhd

I think the error message appears because in your other excel files (second and third) the worksheet name you have specified in the Excel Adapter isn’t available?