Turning my workflow into a macro to use across several excel files in the same format.

[davidorloff]

Hi all, 

I've built a workflow where i've gotten my desired output however i would like to turn this into a macro that replicates this across multiple excel files that are in the same format. Does anyone know the easiest way to perform this or can refer to where I can learn how to do this?

Thanks,

David

[christine_assaad]

Hi @davidorloff 

Please check out this article: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets...

Hope it helps. Cheers!

[DawnDuong]

hi @davidorloff 

Seems like batch macro is what you need. I find the interactive lessons on Macro very good primer for getting started. 

https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Macros

Dawn.