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