When automating Excel using the MS Excel VBO, you may be experiencing the following error:
"Could not execute code stage because exception thrown by code stage: Invalid index. (Exception from HRESULT: 0x800200B (DISP_E_BADINDEX))"
The error indicates that an incorrect reference to the Excel Workbook or Worksheet is being used.
How to resolve this issue
Double-check the parameters being used for the input and output of the Action being used for the VBO.
Also, please also see the following online article:https://stackoverflow.com/questions/28830758/exception-from-hresult-0x8002000b-disp-e-badindex-for-system-runtime-interops
NEW TO RPA?
What is Connected-RPA?
Intelligent RPA Platform
Why Blue Prism?
Contact the Community Team
Blue Prism DX
Privacy & Cookies
Terms of Service
© Blue Prism