Running an Excel Macro Using the Command Tool in Alteryx

Question

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

RolandSchubert · Answer

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

KilianL · Answer

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-Macros-VBA/ta-p/471551

markcurry · Answer

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.,

VBA Execution.yxmd