Extracting metadata from Excel workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-2206380%22%20slang%3D%22en-US%22%3EExtracting%20metadata%20from%20Excel%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2206380%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20workbook%20with%20hundreds%20of%20worksheets.%26nbsp%3B%20%26nbsp%3BI%20am%20looking%20for%20an%20easy%20way%20to%20extract%20the%20worksheet%20names%20into%20a%20list.%26nbsp%3B%20Thanks....%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2206380%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I have a workbook with hundreds of worksheets.   I am looking for an easy way to extract the worksheet names into a list.  Thanks....

2 Replies

Thanks @Hans Vogelaar 

Exactly what I needed....