shrug-l: ANSWER! Off topic question - Windows Explorer
Nonie Castro
nonie_castro@coxtarget.com
Wed, 7 Apr 2004 17:37:19 -0400
Many thanks to you, Bill and Linc and William!=20
I was pretty good at DOS, years and years ago, but Windows has spoiled =
me! I was kind of hoping that Windows would have a nifty little =
Directory Wizard by now! Oh well.=20
Thanks again!
> One way to do what you're trying to do is to open a DOS command prompt
> window (shortcut usually can be found in your Start Menu under the
> Accessories group), then type the commands:
>=20
> cd d: (or whatever you CD drive letter is)
> dir d: -> c:\cd1.txt
>=20
> This will write the directory list to the file c:\cd1.txt =20
> You can copy and
> paste from this text document into Excel. Each time you issue=20
> the second
> command it will overwrite the file named on the right side of the "->"
> characters, so just keep changing that filename as appropriate.
>=20
> Or you can cut out the middle step, just type DIR and copy=20
> and paste from
> the command prompt window. The downside to that method is=20
> it's a little
> clunky if you have a long list of files on the CD.
>=20
> Hope this helps,
>=20
> Bill Beers
> URS Corporation
> 3676 Hartsfield Road
> Tallahassee, FL 32303
> (850) 574-3197
> bill_beers@urscorp.com
__________________________________________________________________
Nonie,
One approach would be to use a command prompt (DOS Window)
Start>All Programs>Accessories>Command Prompt
CD (Change Directory) to the CD drive
cd e: (for example)
List the directory contents and redirect the output to a file
dir /b > c:filenames.txt
where
dir - lists directory names
/b - a dir command flag to list file names only (without date, etc)
> - redirects output
c:filenames.txt - the name of the file into which the output will be
directed
Using the filenames.txt file opened in Notepad, you can copy the entire =
file
and paste it into a spreadsheet.
Good luck,
-Linc Clay
Linc Clay
FDEP/DRAM/BIS/GIS
2600 Blair Stone Rd, MS 6520
Tallahassee, FL 32399-2400
Voice: 850-245-8295, SC 205-8295
Fax: 850-245-8263, SC 205-8263
Email: linc.clay@dep.state.fl.us
__________________________________________________________________
I've had to similar tasks using MS-DOS and the "DIR" command...
Cheers, William=20