Mk-Ninja
|
| posted on 11/5/05 at 09:04 AM |
|
|
List on spreadsheet
Ive got several CDs that contain 40+ folders which I would like to list the folder titles on an excel spreadsheet.
Does anybody know an easy way of doing this so I dont have to type it all in.
Thanks Gordon
I'm sure I've got one, just don't know where I've put it
|
|
|
|
|
simonH
|
| posted on 11/5/05 at 09:13 AM |
|
|
Try this
type dir *. at a dos promt (while in the root of the CD). you will get a list in the box that you can then copy and paste to spreadsheet
Never be afraid to try something new. Remember that a lone amateur built the Ark. A large group of professionals built the Titanic.
|
|
|
Mk-Ninja
|
| posted on 11/5/05 at 09:28 AM |
|
|
I can get a list in a dos box but I'm not able to copy and paste it for some reason.
Is there a different command in a dos box for copy ( Im using Ctl C)
Thanks Gordon
I'm sure I've got one, just don't know where I've put it
|
|
|
Dillinger1977
|
| posted on 11/5/05 at 09:31 AM |
|
|
'dir *. /B >mylist.txt' should produce a text file of that name with whatever was in the dir listings
then open the text file, copy the lot and it -should- paste into each column in a spreasheet
[Edited on 11/5/05 by Dillinger1977]
-Rog
|
|
|
Staple balls
|
| posted on 11/5/05 at 09:32 AM |
|
|
right click
click "mark"
select the info you want
right click again
that'll copythe selected info 
|
|
|
Mk-Ninja
|
| posted on 11/5/05 at 10:24 AM |
|
|
Nice one Dillinger, works a treat.
Sorry Staple Balls I couldnt get yours to work but thanks for trying.
Gordon
I'm sure I've got one, just don't know where I've put it
|
|
|
.jpg)
