xls macro in alteryx

Question

We have a scenario,

We have two macro: say a and b
Data is getting in “a” and the output is used as input in “b”
Macro b runs and creates sheets in the same workbook as an output, we will have some filters and calculations done later.

so can we make alteryx run xls macro a and b?

MarqueeCrew · Accepted Answer

@devmishra,

Please see this article:  https://stackoverflow.com/questions/2050505/way-to-run-excel-macros-from-command-line-or-batch-file

If you can script this to run on the command line, you can have alteryx execute the macro(s) upon completion of a workflow.

Cheers,

Mark