| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Jululian
WHAT ABOUT IF THE xls FILS ARE IN SUB DIRECTORY
REGARDS "Reg" wrote: oh, go on then two ways - build an excel macro what gets the information from windows so can (kind of) keep itself up to date. I am guessing you have no macro background so i offer the much cheaper way:- got to Start, run type "cmd" without quotes and hit return navigate to directory you want to start at (if you need help with this part then close the window and let us know - you arent ready to play in there!) you now going to copy the driectory structure with all excel files to a text file by typing the following at the command prompt:- dir /B /D /N /S /X *.xls files.csv This creates a file called 'files.csv' with a list of all .xls files in the current directory and below. if you type "files.csv" at the command prompt it will be loaded into excel and you have your index. hth RegMigrant "George A. Jululian" wrote: Good morning please help can i create an index sheet for all my excels files (XLS) regrads |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Jululian | Excel Discussion (Misc queries) | |||
| Jululian Excel | Excel Discussion (Misc queries) | |||
| Jululian Excel | Excel Discussion (Misc queries) | |||
| Jululian & Excel | Excel Discussion (Misc queries) | |||
| Excel Jululian | Excel Discussion (Misc queries) | |||
![George A. Jululian[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
