Opening Excel Macro in Alteryx

[Mike_at_CG]

Hi Alteryx Community

I am trying to bring in / run an excel macro into an Alteryx flow I am trying to build.  The Excel macro is saved to a single workbook and runs on open.

I've tried using the below but even after searching around Google I dont know /  understand the VBS script part.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Alteryx-Run-Command-Executing-Excel...

I read the first part of the post to mean the actual VBA was the text input but I think that might be where I am getting lost.

Any help is greatly appreciated as always.

Thank you

[WesCannon]

Hi Mike,

The VBA script should be placed in the 'Command Arguments' field as a VBScript Script File. 

To save the file as a VBScript Script File, copy and paste your script into a text file and save with a .vbs file extension. The file path to this .vbs file will be placed in the 'Command Arguments' field as shown below: