One method:
click Start, Run and type CMD (to run a DOS window)
type CD\MyFolder
using the path to your folder
something like CD\Documents and Settings\MyFiles
type DIR /-b /w ListFiles.txt
to copy a list of filenames to a file
type Exit
to close this window
This file (ListFiles.txt) can be opened into Excel.
Hope this helps
--
Ray A Wrote:
I would like to copy all the file names from a folder in explorer into
Excel.
Is this possible? I am using Window XP and Excel 2003
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=377755