Blue prism- Getting “Cannot create ActiveX component.” error when interacting with Excel VOB operations

Question

I am doing a basic exploration of RPA using Blue prism. When I interacting with Excel VBO operation (Create instance) BP throwing following error.

Internal: Could not execute code stage because an exception is thrown by the code stage: Cannot create ActiveX component.

Object flow:

• Start
• Create instance
• Open workbook
• Get worksheet as a collection

Steps tried to resolve the issue: Re-registered exes both excel and blue prism but no luck.

Error:

Answer 1

I think the reason this is happening because you probably JAB DLL's in various locations.

To solve this, you have to delete all the JAB files which are there in the following locations and by executing the following command you can see all Jab related files sitting in your machine.

dir c:\*ccess*ridge*.dll, c:\*ccess*ridge*.jar, c:\accessibility.properties /s /b

Locations where all JAB files needs to be removed:

1. Windows32
2. SysWOW64
3. Prism Limited\Blue Prism Automate

This solution will work for only 64-bit windows 7 or higher version of OS

1)Make sure you have installed JRE 1.7 or higher version (1.7+ version will have JAB in build, so you don't need to install it externally)

2) Ensure that you have pasted below files under "Blue Prism Limited\Blue Prism Automate" Copy these files from installed jre\bin

• JavaAccessBridge-64.dll
• JAWTAccessBridge-64.dll
• WindowsAccessBridge-64.dll

3) Enable JAB from the windows control panel.

when you do all this it should work fine please comment if it doesn't.