Dynamic Inputs, Directories and Multi-Page Spreadsheets

[rdlouviere]

I am trying to pull a specific file dynamically from a directory so that I get the current year's file when I run it (or the latest document in that file). I know how to do that either way I determine to be the best later on. However, once I pull that specific file, I want to use it to pull in all of the sheet names so that I can create a full file path to dynamically pull in all the multiple tabs within that spreadsheet. 

I tried doing this using a directory tool and filters to get my file path but then using that file path, I want to pull only sheet names which I tried using a dynamic input but I keep getting an error that I have not specified a sheet when I have. Any recommendations as to what I might be doing wrong?

[abacon · Accepted solution]

@rdlouviereDon't use a dynamic input tool. You want to use a macro that gets the sheet names out. Try this one, it is a batch macro that takes each file in a directory (or after your filter) and extracts the sheet names. It will allow you to create the dynamic file path.

Bacon

[binuacs · Accepted solution]

@rdlouviere update your full path like below