Import Multiple Tabs within Multiple Excel Files

[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…