topic Error while running excel macro in Product Forum

Error while running excel macro

RadhikaMittal — Tue, 02 Apr 2019 17:11:00 GMT

I am trying to Run Excel Macro and getting the below error: Internal : Could not execute code stage because exception thrown by code stage: The given key was not present in the dictionary. Can somebody guide how to resolve the issue.

Hi, radhika, please check…

zdenek.kabatek — Tue, 02 Apr 2019 18:59:00 GMT

Hi, radhika, please check that you open the Macro with the right MS Excel VBO. This often happens if you have several MS Excel VBOs in your Blue Prism environment and you call Create Instance Action with MS Excel VBO 1 and then call Macro with Action from MS Excel VBO 2. Regards, Zdenek

RE: Hi, radhika, please check…

Tejaskumar_Darji — Sat, 27 Mar 2021 12:58:00 GMT

Thanks for the answer. I realized I was using different VBOs, and when I streamlines them all to one VBO that error resolved. Thanks for answer.

------------------------------
Thanks & Regards,
Tejaskumar Darji
------------------------------

RE: Error while running excel macro

_Amlansahoo — Mon, 12 Apr 2021 10:06:00 GMT

It may be you are using two different VBOs or another user bight be logged to same server so 2 instance of excel may open.

------------------------------
Amlan Sahoo
RPA Consultant
Equinix
------------------------------