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!
When you click on the macro, use the Browse button and select your own directory.
@navypoint16,
Try using this macro published by @CameronS. It should work wonders for you.
Cheers,
Mark
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
