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

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

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

'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]

right click

click "mark"

select the info you want

right click again


that'll copythe selected info

Nice one Dillinger, works a treat.

Sorry Staple Balls I couldnt get yours to work but thanks for trying.

Gordon