Blue Prism new Excel VBO to color cells

Question

I created an Excel VBO Extension object to add new functionality to the Excel steps. In my new object, I would like to color a cell based on input.

For this, I use the Create instance, Open Workbook, Show actions from the original Excel VBO. The following action is my new action, but I always get the following error: "Internal: Could not execute code stage because the exception is thrown by code stage: The given key was not present in the dictionary."

In my new action I use the Activate Worksheet, CheckInstanceAndWorkbook, CheckInstanceHandle actions copied from the original Excel VBO and recreated in my new Excel VBO Extension object.

How can I catch the instance with my object, that has been already created by teh original Excel VBO?

Thank you.

Answer 1

The actions performed are 

• Create instance

• Open Workbook

• Show actions from the original Excel VBO

these belong to different part of code though

Since your new object is under your Excel VBO Extension along with Activate Worksheet, CheckInstanceAndWorkbook, CheckInstanceHandle actions that were recreated, they do not have access to the handle variable created by a different object

duplicate the original Excel VBO to your Excel VBO extended and use actions of one object only.