List all Tab names in Excel workbook

Question

Hi - is there a way to import all the names of sheets within a workbook? I am using the directory input to pull in a bunch of files and unfortunately all of the workbooks have different tab names, based on the month-year (and they're not even consistent, some are JUNE-16 or JUN-18 for example).

Wondering if there is a macro somewhere that can read all sheet names from multiple workbooks.

thanks!

messi007 · Answer

@jenner85,

Could you share a sample of your data and the workflow please.

It will help to fix the problem.

Best Regards,

jenner85 · Answer

Hi @apathetichell @messi007  I tried to import from all my workbooks using import list of sheet names and it is only working for some of the files:

jenner85 · Answer

Hi @Kenda thank you - It is working for about half my files, the other half are coming up like this: