Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
listing all sheets in all workbooks in a directory
Hey
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 fo rthis? Thanks Todd |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Directory listing | Excel Discussion (Misc queries) | |||
Listing Directory Contents in Worksheet | Excel Discussion (Misc queries) | |||
Directory listing | Excel Discussion (Misc queries) | |||
Directory listing manipulation | Excel Programming | |||
Recursive directory listing | Excel Programming |