First thanks on your support

please i did not undersatnd that can you be more clear

regrads

"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