Thread: copy & paste
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bryan Hessey
 
Posts: n/a
Default copy & paste


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