This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
For Excel Files, you'd need to either use a formula to specify the sheet names you'd like to load, or use a macro to dynamically load all sheet names (if loading all sheets) for each file before using the multi load macro.
The inside of the multisheet macro looks like this:
Pay close attention to the use of the <list of sheet names>
This tool opens each excel file 1 at a time to collect a list of the sheet names.
The action tool serves to replace just the specific string "FileA.xlsx" while still maintaining the <list of sheet names> suffix.
The formula tool replaces the suffix with each sheet name that is loaded.
A row for each sheet name is returned from the macro providing a Fullpath for each sheet. This is the parameter that should be used in the Multi File Load Macro.
Please let me know if this is able to resolve your issue.