Auto Selection of Files based on the user's chosen sheets using chained application

Question

I'm seeking a way to have files automatically chosen in analytical apps, taking into account the sheet selections made by the user.

For instance:

Step 1:Actual Data

File 1sheet 1sheet 2 File 2sheet 3sheet 2 File 3sheet 2sheet 4

Step 2: User will Manually select sheets (At this point display all the sheet names from the files provided by the user and User should be able to select sheet names manually)

sheet 1sheet 2sheet 3sheet 4

Step 3: Automation should handle the automatic selection of files within those specified sheets. Note: User should also have the choice to deselect file selections if needed.

sheet 1File 1 sheet 2File 1File 2File 3 sheet 3File 2

Rao2821 · Answer

Thank you @ChrisWaspe,.

As a solution:
I used Directory tool and sheet name pull macro. A chained app using Tree interface tool.

ChrisWaspe · Answer

Hi @Rao2821 . You would most likely want to use a Dynamic Input tool. You can build out the file path string using the results from the various selections and configure a Dynamic Input tool to read in those files. A chained app could provide a list of the file strings after the sheets have been selected. The user could chose which of these strings they then want to pass to the dynamic input tool