View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sunny Sunny is offline
external usenet poster
 
Posts: 42
Default Extracting Worksheet names within a spreadsheet

Is it possible to extract the name of all the worksheets within a spreadsheet.

On a monthly basis I have a spreadsheet that have a worksheets added. I
need to identify which worksheets are new.

In a nutshell I require a contents page on the first worksheeting listing
what all the worksheet names are with the spreadsheet.