Adding Excel Macro in my Workflow

fjlorenzo

Hi Everyone,

Can someone help me update my existing workflow. I need to do the following:

1. Download a file on a daily basis - this is already done
2. Add the current date on the daily file
3. Add my Excel macro and run this macro from the latest file
4. Email the file

Thank your help,

Florence Lorenzo

danilang

Hi @fjlorenzo 

There's no way to add a macro to an existing Excel file using Alteryx.   You can only write data and formatting.  What you can do is write the data to an existing template file that already has the macro included

1. Copy the template file to a temp location using the blob method from here. 

2. Write the data to the file

3. Invoke the macro using a vbs solution like the one shown here

4. email the new file using an email tool 

Dan