Union Folder

[navypoint16]

Are you able to use an entire folder of .xlsx files as your input and then union them into one file?  I'm finding this works for csv files, but having trouble making it work for Excel.

Thanks!

[MarqueeCrew]

@navypoint16,

Try using this macro published by @CameronS.  It should work wonders for you.

Cheers,

Mark

[navypoint16]

Thanks for sharing!

I'm not sure I know how to leverage the macro for my own use.. it opens as a flow between an excel file opener and a browse.  Am I missing something?

Thanks

[MarqueeCrew]

You should be able to point to the directory that has all of the excel files and it will read all of your files in one tool.

[navypoint16]

How do I drop my own excel files into that directory?  It looks like it's filled with sample data.. I'm not able to manipulate it within the workflow.

[DavidxL · Accepted solution]

When you click on the macro, use the Browse button and select your own directory.