Ok...you're gonna love this: DOS!!

Yes, you could write a program, but this is so easy:

1)You need to know the complete path to your Excel files
In my case: C:\ANALYSIS\

2)Open a new text file and enter this text:
dir/b c:\analysis\*.xls c:\mylist.txt

Note: you'll need to replace my locations with yours

3)Save that file to your desktop as ListXLFiles.BAT, then close it.

4)Display your desktop and double click that file.

5)In Excel, open c:\mylist.txt
In the file import wizard, uncheck all delimiters and click [Finish]

There's your list of filesl
Now you can copy that list and PasteSpecialTranspose to the
horizontal array of cells that you want to contain the list.

Does that help?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=375741