Process Steps after Using Output tool

[Muralisagar]

I have a process where I need to import data from a database and copy that into an existing excel template & run Excel Macro

I have used output tool to copy data into the template, do I need to create a separate process to run the Macro

please advise

[Emil_Kos]

Hi @Muralisagar,

This is the article that can help you with running the macro from Alteryx:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Alteryx-Run-Command-Executing-Excel...

What I would suggest is start testing it but I believe you can run this in the same workflow using block until done tool.

Use block until done so you will not start a cmd that runs the macro before the output is saved.

Please see article below to find out how to use block until done tool:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Output-a-file-and-re-input-it-withi...

Good luck!

[gsantos]

Hi @Muralisagar , thanks for reaching out

If I got it right you need to run an excel macro after copying the data into the spreadsheet, is that so?

If that's the case and assuming we're talking about a VBA Macro, what I would do is:

1- Use the Block Until Done tool before the output to ensure this will be the first step.

2- Create a script to run your Excel Macro, this article is pretty useful.

3-Use the Run Command Tool in the anchor #2 of your block until done tool tool to run your script file, or even a batch opening the script. This other article right here can help you out on this one,

Hope it helps, and feel free to reach if you need further assistance with this.