Invoke Alteryx using Excel VBA

Question

Hello!

I have been using the following code in a model to run Alteryx

Sub Alteryx()

RunMod = ShellAndWait("""C:\Program Files\Alteryx\bin\AlteryxEngineCmd.exe"" ""\[FOLDER PATH]\VBATest.yxmd""", 0, vbNormalFocus, PromptUser)

End Sub

The ShellandWait code is in another module and is  from here - http://www.cpearson.com/excel/ShellAndWait.aspx.

When I run the macro from Alteryx, it does find the Alteryx Engine but does not run the workflow.

What am I doing wrong? Is it a license issue?

echuong1 · Answer

As mentioned above, you need to have a license that includes access to the AlteryxEngineCmd.exe. This is included with either one of our server products (Alteryx Server or Alteryx Analytics Hub) or a Scheduler license.

If you are interested in either, please reach out to your account executive. We'd be happy to discuss your options and set up a trial if you'd like!

AkimasaKajitani · Answer

If you run the workflow via Command Line, you must have Automation add-on license.

Please see this URL.
https://help.alteryx.com/current/designer/run-workflows-command-line