The command
dir *.* /b /o > "folder.csv"
will give you a file that will readily open in excel simply by clicking on
it since .csv is an Excel associated file type, it will be only one column
wide, with the filenames sorted alphabetically ascending in column A. The
quotes are necessary if you want to use names for folder that are longer
than 8 letters or if the name has any spaces.
dir *.* /b /s > "folder.csv"
does the same thing except it includes the whole pathname, with all the
folders and sub-folders, like
C:\windows\system\wallpaper.bmp
instead of
wallpaper.bmp
Tom Turak
-----Original Message-----
From: Dave Jones [mailto:[log in to unmask]]
Sent: Thursday, July 17, 2003 1:36 AM
The easiest way (depending on the format you want) is to open a command
prompt and do this:
dir > dir.txt
if you;re in the C: directory it will create a text file with the directory
of the files.
This is what part of my temp dir looks like:
Volume in drive C is Morpheus
Volume Serial Number is 2484-2AAF
Directory of C:\Temp
07/17/2003 12:34a <DIR> .
07/17/2003 12:34a <DIR> ..
07/15/2003 01:41p 70,916 2
07/15/2003 01:43p 70,916 3
07/15/2003 01:44p 58,180 4
07/15/2003 01:45p 89,988 5
07/16/2003 01:32p <DIR> Adobe
07/16/2003 01:47p <DIR> CAPTDIR
07/16/2003 10:32a <DIR> ftpurls
Hope this helps
Dave Jones
D&D Video Productions
http://www.vdoguy.com
Camel: A horse designed by committee
----- Original Message -----
From: "John Dent" <[log in to unmask]>
To: <[log in to unmask]>
Sent: Wednesday, July 16, 2003 7:31 PM
Subject: [PCSOFT] Copying File Titles
> Does anyone know how to copy file titles from Windows Explorer so I can
> sort the file titles in Word or Excel etc. I would like to be able to Cut
> and Paste the titles to other programs. (Is there a program that can do
it?)
>
> So far this seemingly simple task has no answer.
>
> Thanks
>
> John
>
> Do you want to signoff PCSOFT or just change to
> Digest mode - visit our web site:
> http://freepctech.com/pcsoft.shtml
The NOSPIN Group is now offering Free PC Tech
support at our newest website:
http://freepctech.com
The NOSPIN Group is now offering Free PC Tech
support at our newest website:
http://freepctech.com
|