excel VBA to control Alteryx analytics app

[Inactive User]

Hello all, is it possible to make a excel VBA to change the input of Alteryx analytics app and execute it?

I searched over different webpage, I can use VBA to open the alteryx apps, but cannot figure out how to edit and run it, thanks:)

[TimN]

Hi,

see if this link helps.

https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Excel-to-Alteryx-API/ta-p/85766

[apathetichell]

Within the terms of your license agreement?

[TimN]

Do you have Alteryx server?

[Inactive User]

no, i don't, what will it affect if i don't?

[PanPP]

You can leverage Alteryx Server APIs as described in the article below

https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Excel-to-Alteryx-API/ta-p/85766

[Inactive User]

thanks for the reply, but i don't have alteryx server, so I can't find the unique alteryx key and secret, 

or is it work even i don't have an alteryx server? thankss

[apathetichell]

You cannot do what you are trying to do within the terms of a Designer license agreement. The automations discussed will be limited to Server and/or Scheduler.

[Inactive User]

i see, thanks for the info

actually, i would like to solve this problem
Re: How to loop within the value in the drop down ... - Alteryx Community

i built a alteryx analytics app that output the file by selecting the drop down list

but the problem is: there are many value in the drop down list, which need to be run each

so i'm looking for a method that can click running the app one time, instead of click running it many times. 

I search many webpage, but still can't get a answer.. nvm thanks for your reply

[apathetichell]

Directory tool - batch macro. You update your input data tool inside the batch macro with the path from the directory tool.