Does Alteryx have the ability to refresh a specific query in Excel?
Thanks
Neel
I built a macro that refreshes all data connections in the excel file you point it at. It just uses cscript. You'd have to play around with it to get it to do only one specific data connection, but if you open it up and take a look at what I'm doing it shouldn't be hard to figure out.
Hey @npatela4,
I'm sure you could do it using the Python tool though I cant think of a more straight forward way. What are you querying out of interest, would it not be easier to run the query in Alteryx?
Thanks a lot! I will try this.
Hi
Thank you for this wonderful post. What should be done if I want to connect this macro to one of my workflow. This macro should run first before the other workflow tools.
