Microsoft Office.Interop error

[GavinRudling]

Good Day all

I have loaded an Excel Enhanced VBO and I am getting the following Error

I have taken a copy of the library file and placed it in the same Blue Prism folder with the Automate C executable which happens to also contain the microsoft office.outlook.interop file.
I have restarted Blue prism and then the VM and I still get the same error. Any suggestions. am I still missing something?
I am using the BPC platform running 6.10.3

Kind Regards
Gavin

------------------------------
Gavin Rudling
Digital Consultant & Developer
Cog3nt
Africa/Johannesburg
0813906789
------------------------------

[MichealCharron]

@GavinRudling

I don't know if it is the image quality but looking at it you are missing the period between "Microsoft" and "Office".​

------------------------------
Micheal Charron
Senior Manager
RBC
America/Toronto
------------------------------

[PabloSarabia]

Hi @GavinRudling

Is this a copy from the "MS Excel VBO"​?

The namespace that is using the original VBO is this one: "System.Runtime.InteropServices"

Can you show us the "Code Options" Tab for the object to check all the libraries?


See you in the Community, bye 🙂

------------------------------
Pablo Sarabia
Solution Manager & Architect
Altamira Assets Management
Madrid
------------------------------

[GavinRudling]

Hi All,

Thank you all for the rapid responses.
The issue is resolved, there was a typo (.) missing from the Microsoft.Office.Interop.Excel.dll sting.

------------------------------
Gavin Rudling
Digital Consultant & Developer
Cog3nt
Africa/Johannesburg
0813906789
------------------------------

[NileshJadhavBP]

Thanks Gavin for confirmation

------------------------------
Nilesh Jadhav
Senior RPA Specialist
ADP
India
------------------------------