This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have previously posted my question to see if adding a filter (one like in excel) was possible to my output tool or in my case im using Basic Table/Render tool to generate my output. I was able to create my macros and ran it successfully with the output tool.
However, this doesn't seem to work the same when running with Render tool.
It looks like my filters are getting added to another file which I cannot seem to find but it displays for a quick moment when the macros run.
This is the file I cannot seem to find as it closes right away
This is the .vbs file I found in the Alteryx community
You could eliminate the use of the After run event, by using a bnlock until done tool ensure your Excel file is created first by the Render tool, and then execute the Run Batch command as in the example.