| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List of Excel files
I need to get a list of excel files from a directory so
that I can open them one at a time to get information out of them. I will also need to figure the names of the worksheets in the files, as each worksheet will have the same info that I need. Any help would be appreciated!!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
List of Excel files
look at the help example for the dir command or use the filesearch object.
-- Regards, Tom Ogilvy "dfrancefort" wrote in message ... I need to get a list of excel files from a directory so that I can open them one at a time to get information out of them. I will also need to figure the names of the worksheets in the files, as each worksheet will have the same info that I need. Any help would be appreciated!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List of saved Excel files | Excel Discussion (Misc queries) | |||
| How do I get a complete list of my EXCEL files? | Excel Discussion (Misc queries) | |||
| How to get a complete list of All my EXCEL files? | Excel Discussion (Misc queries) | |||
| List Files in excel | Excel Discussion (Misc queries) | |||
| Getting list of files in a folder to excel | Excel Programming | |||
Linear Mode
