Multiple Tab input

KANNAM2

How To: Import multiple tabs from one Excel file which has different Schema. I found various solutions to input multiple tabs from multiple files with different Schema using a batch macro. In batch macro's i need to specify the sheet name, the reason i do not want to use batch macro as the file has 30+ tabs with different tab names and schema.

MichalM

There's a problem with the configuration of your macro. 

The Input data tool within your macro needs to be configured to open one of the sheets within the file. And the data your passing into the macro through the control parameter (list of sheet names) will dynamically replace the reference to the sheet name.