Excel application scope : Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))



Hai all, am getting the above mentioned error, can I know the the reason for that error.And am using the excel 2007. The below is the xaml file attached.
Main.xaml (7.9 KB)



on the second excel activity you are calling for “writeExcel.xlsx” but if you rare using Excel 2007 it probably wants the old suffix "writeExcel.xls`?


Ok, thanks @AlexJank.


hi @AlexJank, given the xls file but getting the same error…


sorry, @sushmithaelluru, I can’t reproduce the error - I actually tried your xaml and it worked fine for me (I have Excel 2016 though)


Your workflow works for me too.

Can you try changing your output workbook to .xls?


Ya worked for me @CBlanchard. Thanks.


Ok @AlexJank. Thanks.


Good to hear :slight_smile:


Hi, I am getting the same error. I am using Excel 2016 though


Do all your excel file types match?


Hi, it’s okay, I figured it out. I had to kill the excel task running behind and try again. Thank you :slight_smile:


Ya ok.Thanks @CBlanchard.