cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to use Move Worksheet Action

RakeshDey
Level 3
Hi, I am trying to move/copy sheet (from a .xls to .xlsx and even tried on .xlsx to .xlsx file)using Move Worksheet Action but am getting the following error:- Failed to move worksheet: Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX)) I made sure that all the parameters passed are correct and are not empty. PFA. Any positive response would be highly appreciated.
3 REPLIES 3

ViktorKral
Level 3
Hi, Im having the same problem, would be really glad for any help. Thanks!

AodhanCarberry
Level 3
Hi,  I came across the same issue as well. Was anyone able to work out a solution? Thanks

BellaKoh
Level 3
Hi all, Both source and destination workbook must be opened using the same instance handle. If they are opened with different handles, it will cause the index error.