load multiple excel files from a folder

[Himal]

Hi,

I am trying to build a macro to load multiple excel files from a folder. It would be great if there is a sample workflow and apps in the designer, to simulate the data.

Thanks.

[AS]

how could we proceed further after that I want to combine all files data. how could I do that

[NNOLTE]

5 years later and this helped me a lot. Thanks @neilgallen for the tipp regarding the sheet name! Dynamic Input did its charm