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.
the "dir /b /d /n /s /x *.xls > files.csv" line, will, if entered at a
command prompt, list all of the .xls files from the current directory and
every sub-directory in the tree below it - so if you run it in the root
directory of C: (ie: C:\>dir /b /d /n /s /x *.xls > files.csv) it will list
every xls file on your c: hard disk
If the problem is that you dont understand the use of command prompt and
"dir" command in the first place then I suggest you go down the route of
using a macro instead.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
