Dave Peterson and LenB responded to this post yesterday.

Im sorry I forgot to state that I needed this without actually opening
any workbooks.

Below is what I need:
I need to list all the worksheets in all the workbooks in a specfic
directory.


I need it to look in C:\Test and list the Workbook name and the sheet
name next to it. For example:
Workbook1 - Sheet1
Workbook1 - Sheet2
Workbook1 - Sheet3
Workbook1 - Sheet4
Workbook2 - Sheet1
Workbook2 - Sheet2
Workbook2 - Sheet3


What is the code for this?