Running an Excel Macro Using the Command Tool in Alteryx

[Sonalik10]

When I try to use the command tool to run my excel macro found in my excel sheet I am getting an error that I need an output. When I put an output I get another error stating that the "external program "cscript" returned an error code:1 "

 I followed this video step by step but am still seeing problems. 

https://www.youtube.com/watch?v=k3RqxUc25ig 

[markcurry]

Hi @Sonalik10 

If you click on the 'Input..' button, is the file format set to a CSV file, and do you see the .vbs code?  

I see from the screenshot that you have "\VBA_Example.vbs" as the argument.  This would mean that is' expecting the VBScript file to be in C:\VBA_Example.vbs , so if you remove the \ , it should expect it in the same location as the workflow.

I've a attached a version of the workflow, so hopefully that works for you, if the above suggestions don't.  Hope that helps.,

[KilianL]

You can also compare your setup with this knowledge base article: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Alteryx-Run-Command-Executing-Excel...

[RolandSchubert]

Hi @Sonalik10 ,

I think, adding an output file to the Run Command tool should solve your problem. You could e.g. add something like "temp.yxdb" as output (Write Source). I've used this logic in some workflows, it seems, a kind of dummy output file is needed.

Best,

Roland