cancel
Showing results for 
Search instead for 
Did you mean: 

Invoke VBA (not using Run Macro action) feature

YunaLee
Staff
Staff


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
31476.png
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.
31477.png
Macro file recored is very simple as following
31478.png
Any and all advice is very much appreciated.

Thanks!



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

GeoffHirst
Staff
Staff

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
------------------------------
Geoff Hirst Senior DX Engineer - Digital Exchange - EMEA SS&C Blue Prism

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

Thanks
Yuna



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