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 don't think it's possible to add a macro to an excel file using Alteryx. What you can do is have a an excel template file that already has the macro embedded and use Alteryx to fill in the data sheets.
This is possible to do through the Run Command tool. You will have to learn some basic VB code to create the script that would populate the Run Command tool. Here is a good link to get you started: vbscript
Also here is a good link for the Run command tool: RunCommand
Once you have the script that would run the macro, you would just need to incorporate the script into the workflow that you are using to update the data. Example:
I was able to get this to work before where the data populated and then the macro updated the report and sent an email all in one workflow.
SAP using VB scripting for macros: I'm looking to run a VB script to ask SAP to run a query, save a file, and then use that file in the workflow. I can't seem to nail the sequencing down. I'm thinking I may need to create a macro to run the VB scripting and use that in the main. Any thoughts? Recommendations?