Thanx Duke- ended up using "Printfolder" a neat piece of software with a nice
GUI.
http://no-nonsense-software.com/freeware/


"Duke Carey" wrote:

One way is to open a DOS command window, change directories to the one you
are interested in, and use the DOS command

dir *.xls list.txt

which will create a text file named list.txt containing a listing of all the
XLS files in that directory. You could then open it in Excel and parse it


"ROD" wrote:

I have approx 700 excel files that I want to copy the "names of", to a list
in one Excel spread sheet. (Easily?). Please help?