Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Running Excel Macro VBA Script through Run Command

HarishKhanna1
7 - Meteor

Can anyone share a sample workflow using Run command tool to run the excel macro VBA script (.vbs extension) and .xlsm file 

4 REPLIES 4
danilang
19 - Altair
19 - Altair

Hi @HarishKhanna1 

 

Try the example in this knowledge base article

 

Dan

HarishKhanna1
7 - Meteor

Thanks Dan. If I have to create a new macro within other excel workbook, What should be the configuration of the run command tool (assuming that I have .xlsm file and .vbs file ready) ?
Thanks, In advance..

Qiu
21 - Polaris
21 - Polaris

@HarishKhanna1 
I made one sample before. Hope it can help/

 

HarishKhanna1
7 - Meteor
I am getting below error while I am running the workflow..But .vbs file is externally running using windows without any error..Please help me with the configuration of run command tool here

Capture.PNG

Labels