18-04-23 08:17 AM
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!
18-04-23 02:13 PM
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
27-04-23 09:03 AM
Hi, Geoff
How can I contact you internally? Should I create a ticket?
Thanks
Yuna