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

activities

#1

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)

Thanks.


#2

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`?


#3

Ok, thanks @AlexJank.


#4

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


#5

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


#6

Your workflow works for me too.

Can you try changing your output workbook to .xls?


#7

Ya worked for me @CBlanchard. Thanks.


#8

Ok @AlexJank. Thanks.


#9

Good to hear :slight_smile:


#10

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


#11

Do all your excel file types match?


#12

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


#13

Ya ok.Thanks @CBlanchard.