Running Excel Macro

[IzaanMaredia]

Hi
I am using BluePrism version 6.6 
Run Macro is only available on MS Excel Extended VBO
When I select Run Macro option , I am getting the following error

Business Action - MS Excel VBO - Extended
Action - Run Macro
Handler = [handle]
Macro Name = "test.xlsm!welcome"

welcome is the name of the Macro and test.xlsm is the file
I am getting following error. 
Internal : Could not execute code stage because exception thrown by code stage: The given key was not present in the dictionary.

I am able to Create Instance/Open Workbook /Show Work book , It all works
but Run Macro fails

Please Help

Thanks

------------------------------
Izaan Maredia
------------------------------

[AloknathSingh]

Hi Izaan,

Send the Macro name as "welcome".
No need to send the file name under macro name input.
Let me know if it works for you.


Regards,
Alok

------------------------------
Aloknath Singh
Senior RPA Developer
Jaguar Land Rover
Asia/Kolkata
917021429197
------------------------------

[MartinCattroll]

Hey Izaan,

It sounds like you mixed between using the standard excel VBO library and the excel extended VBO library, from what I have seen, this is what normally causes that error. Changing all of your actions to use the excel extended VBO only, should resolve this.

All the best,

Martin

------------------------------
Martin Cattroll
------------------------------

[John__Carter]

Martin and Alok are probably both right. Generally 'The given key was not present in the dictionary' implies the VBO has no 'awareness' of the Excel file. The VBO keeps track of the instances and files it is using, and each time you perform an action it checks in its 'dictionary' to see it is 'knows' which instance/file to work on.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------