topic Invoke VBA (not using Run Macro action) feature in Product Forum

Invoke VBA (not using Run Macro action) feature

YunaLee — Tue, 18 Apr 2023 07:17:00 GMT

Hi all,

I have recored macro on Excel and would like to invoke VBA script on a certain excel file through Blue Prism like UiPath's activity 'Invoke VBA' which allows VBA to run as .txt type as following

I'd rather invoke VBA script (.txt type) than 'Run Macro" action.

So I'm trying "Execute Script" action in Script Execution VBO found in DX
But I'm not sure what I should put in ScriptEngineFilePath.

Macro file recored is very simple as following

Any and all advice is very much appreciated.

Thanks!

------------------------------
Yuna Lee
Solution Consultant
Blue Prism Korea
------------------------------

RE: Invoke VBA (not using Run Macro action) feature

GeoffHirst — Tue, 18 Apr 2023 13:13:00 GMT

Hi Yuna,

The script execution VBO was meant to allow the execution of Python and Powershell scripts, hence the requirement for scriptenginefilepath so you could tell the VBO where your python/powershell application resided.

I know that the Excel VBO will allow the execution of a macro, however to execute your VBA script, as shown above, you would need to place this into a code stage and most likely import some libraries.

Feel free to contact me internally and we can see what we can resolve.

regards

------------------------------
Geoff Hirst
Senior DX Engineer - Digital Exchange - EMEA
SS&C Blue Prism
------------------------------

RE: Invoke VBA (not using Run Macro action) feature

YunaLee — Thu, 27 Apr 2023 08:03:00 GMT

Hi, Geoff
How can I contact you internally? Should I create a ticket?

Thanks
Yuna

------------------------------
Yuna Lee
Solution Consultant
Blue Prism Korea
------------------------------