How to read multiple XLS files

[bjschwartz3]

I'm trying to read in a bunch of XLS files. All the files are in the same directory or subdirectory. All the files have different tab names. I tried to use the batch macro found in https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t... but I get the error 'No table chosen; Please select a table from data source. Any ideas on how to fix?

[tsturge]

I recommend you try these Crew Macros, we have a lot of luck with these and excel even when the headers are different.