Import Multiple Tabs within Multiple Excel Files

[MarioBudiman]

Hi,

I'm looking to import multiple tabs within multiple excel spreadsheets in the same folder.
All of the tabs name start with either 'P-' or 'C-'. Just wondering how do I go about doing it?

Thank you in advance.

[dgudkov]

Hi Mario,

Check out this topic:

Multiple files, small variation in sheet name, import with parameter

Hi, I’m going to import a folder with a number of files with almost same structure - only variance is in the sheet names in the excel files. When importing multiple files, with different sheet names, how do I make a parameter to match for 22 rightmost characters in the sheet name? The sheet name is 31 characters long, and the final 22 are matching. Examples for variances on 9 first characters in sheet name; xxzeb0293 edzeb5581 zzzeb0989 22 rightmost characters (common for all files) exc…

[MarioBudiman]

Thanks Dmitry, this is exactly what I'm looking to do!

[dgudkov]

You're welcome!