Inputting folder of multiple excel files with one uniquely named tab each

[JStuhler]

I used this post CS Macro Dev: Reading in Multiple Files with Different Field Schema - Batch Macro and have built a Batch Macro to read multiple xlsx files from a folder and it works well. The issue is I need it to read a folder of .xslx files that all have one tab each, and each of them are uniquely named. It tells me "No sheet specified, you must specify a sheet."

[binuacs]

@JStuhler try the batch macro

[JStuhler]

Thanks for your reply! This batch macro works great to bring in all sheets into one file from the directory. Is there a way to do this same process, but bring in one sheet from the directory at a time? I need to import one sheet from the directory at a time and run it through other macros before it's joined with the others at the end. 

[binuacs · Accepted solution]

@JStuhler my understanding is that you need to read one input file at a time and import one sheet from that file and run your macro for further processing? 

attaching a sample workflow

1. macro1 - reads the file names and sheet names from the given directory

2. macro 2 - combines the data --> inside the second macro you can add your macro for further processing

[JStuhler]

That worked perfectly! Thank you for your help!