I need to make a list in Excel of all the files on my C:
drive, folder by folder.

I can't find any command in Explorer to export the file
structure in this manner.

Can anyone help?

Hi,

Go to a dos prompt. go to the c:\ if u want the listing of that drive.
type this command dir > somefile.txt
this will print out the contents of the directory to the text file.
then you can export that text file to Excel.

Regards
M. Rajesh
..Net and Windows Shell MVP
www.winxpsolution.com

"Chris Beckett" wrote:

> I need to make a list in Excel of all the files on my C:
> drive, folder by folder.
>
> I can't find any command in Explorer to export the file
> structure in this manner.
>
> Can anyone help?
>

Many thanks !

I was also directed to a freeware program called msls.exe
that allows me to print out the entire directory
structure in one go with all subfolders. I think using
DIR requires manually working your way through them one
by one, and running DIR each time ?

That means a lot of work in my case !


>-----Original Message-----
>Hi,
>
>Go to a dos prompt. go to the c:\ if u want the listing
of that drive.
>type this command dir > somefile.txt
>this will print out the contents of the directory to the
text file.
>then you can export that text file to Excel.
>
>Regards
>M. Rajesh
>..Net and Windows Shell MVP
>www.winxpsolution.com
>
>"Chris Beckett" wrote:
>
>> I need to make a list in Excel of all the files on my
C:
>> drive, folder by folder.
>>
>> I can't find any command in Explorer to export the
file
>> structure in this manner.
>>
>> Can anyone help?
>>
>.
>

Put the parameter "/s" after dir, and youl gett a _very_ long list of all
the files on your computer, directory by directory..... to put the output in
a file to edit it, append ">\directories.txt"

Of course without citation marks...


--
Tumppi
Reply to group
=================================================
Most learned on nntp://news.mircosoft.com
Helsinki, Finland (remove _NOSPAM)
(translations from FI/SE not always accurate)
=================================================

"Chris Beckett" <(E-Mail Removed)> kirjoitti viestissä
news:360801c47ecf$633a6d40$(E-Mail Removed)...
> Many thanks !
>
> I was also directed to a freeware program called msls.exe
> that allows me to print out the entire directory
> structure in one go with all subfolders. I think using
> DIR requires manually working your way through them one
> by one, and running DIR each time ?
>
> That means a lot of work in my case !
>
>
> >-----Original Message-----
> >Hi,
> >
> >Go to a dos prompt. go to the c:\ if u want the listing
> of that drive.
> >type this command dir > somefile.txt
> >this will print out the contents of the directory to the
> text file.
> >then you can export that text file to Excel.
> >
> >Regards
> >M. Rajesh
> >..Net and Windows Shell MVP
> >www.winxpsolution.com
> >
> >"Chris Beckett" wrote:
> >
> >> I need to make a list in Excel of all the files on my
> C:
> >> drive, folder by folder.
> >>
> >> I can't find any command in Explorer to export the
> file
> >> structure in this manner.
> >>
> >> Can anyone help?
> >>
> >.
> >