cancel
Showing results for 
Search instead for 
Did you mean: 

Error while running excel macro

RadhikaMittal
Level 2
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.  
3 REPLIES 3

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

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

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
------------------------------
Regards,
Amlan Sahoo