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

Question

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

DawnDuong · Answer

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.

Christine_Assaad · Answer

Hi @davidorloff

Please check out this article: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets-or-a-Specific-Excel-Range/ta-p/398220

Hope it helps. Cheers!