I did a little checking, this trick works really nice. In either windows
explorer (if you prefer, I don't) or my computer, go to a folder where you
want a list of filenames. Right click away from an icon (else 'new' won't
be one of your choices), and Choose 'New' and one of the choices is 'text
document'. Click Text Document. A file will be created called
New Text Document.txt
and the cursor will be positioned to rename it. Change the name to
filename.bat or any name of your choice as long as the ending is ".bat" so
it can be executed later.
Right click on filename.bat, and choose EDIT, not OPEN. This is important,
open will run the file, not open it. When it opens, it will be empty. Put
this line in it:
dir *.* /b /o >filename.csv
or you can use the name of the folder you are currently in, remembering that
any name longer than 8 letters, or that contains spaces must be in quotes,
like this
dir *.* /b /o >"my documents.csv"
Save and exit. Now just double click on filename.bat. Close the resulting
dos box. (You can avoid this step by first doing a right-click on the
filename.bat icon, choose properties, and check the box 'close on exit').
Click View,Refresh, so that the .csv file you just created is displayed in
the active folder window. Double-click on this .csv file, and Excel will
load with the files from this folder listed in alpahbetical order.
Clean up the .bat and .csv files after you are through.
Tom Turak
-----Original Message-----
From: Tom Turak [mailto:[log in to unmask]]
Sent: Thursday, July 17, 2003 9:00 AM
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
The NOSPIN Group Promotions is now offering
Mandrake Linux or Red Hat Linux CD sets along
with the OpenOffice CD... at a great price!!!
http://freepctech.com/goodies/promotions.shtml
|