topic RE: Excel VBO Compile Error in Product Forum

Excel VBO Compile Error

ZdravkoBotushan — Thu, 30 May 2019 12:07:00 GMT

Hey guys,

I am trying to use the Excel VBO, however, I am getting a compile error every time I try to use any of the actions.

I opened the Excel VBO, this is the list of errors:

I tried re-importing the VBO

------------------------------
Zdravko Botushanov
Senior RPA Consultant
------------------------------

RE: Excel VBO Compile Error

AmiBarrett — Thu, 30 May 2019 15:18:00 GMT

Any error with a negative line number would be in the imports or global code. It looks like you're trying to reference a temporary file, which isn't recommended.

------------------------------
Ami Barrett
Lead RPA Software Developer
Solai & Cameron
America/Chicago
------------------------------

RE: Excel VBO Compile Error

ZdravkoBotushan — Fri, 31 May 2019 10:19:00 GMT

Hello,

I don't think this is the case, because all of the Blue Prism VBO objects (e.g. Excel, Utility- General and all utility objects) do not work.

Every time I try to debug, the error gives me a different file is missing.

------------------------------
Zdravko Botushanov
Senior RPA Consultant
------------------------------

RE: Excel VBO Compile Error

AmiBarrett — Fri, 31 May 2019 16:45:00 GMT

The second line from your error log is pointing to a file in C:\Windows\Temp. If it's not directly referenced within the object, it could be something Blue Prism is trying to do in the background.

This directory usually requires administrative permissions to access, so it seems odd that it would be referenced. But just to rule something out, try running Blue Prism as an administrator and see if that fixes the issue. If it does, try completely uninstalling and reinstalling.

------------------------------
Ami Barrett
Lead RPA Software Developer
Solai & Cameron
America/Chicago
------------------------------