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

[fjlorenzo]

Thank you @danilang I'm not sure if I would be able to do this.

[fjlorenzo]

Hi @danilang I would appreciate if you could share your Alteryx workflow to me. Thank you.

[fjlorenzo]

Hi @JoeL,

I need to add an Excel macro to my workflow. I tried your sample workflow. I change the workbook name and Excel macro name from your sample .vbs file but my output was incorrect. For the input tool should I use the file that I'll be using for my Excel macro?

Also, I didn't quite understand what file should I put on the "Write Source" option. Appreciate all your help to get my workflow work.

Thank you,

Florence Lorenzo