Display Explorer Folders Tree Structure and Export to Excel

Archived from groups: microsoft.public.windowsxp.basics (More info?)

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?

Archived from groups: microsoft.public.windowsxp.basics (More info?)

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?
>>
>.
>

In Windows:

1. Start – Programs – Accessories – Command Prompt [This will open the DOS screen]
2. Type: D: ENTER [where D is the drive you want to go to and ENTER is the enter key]
3. Type CD\directory1\directory2\directory3 ENTER [where directory1, 2, 3 are the directories you want to “tree”. Add more directory names as appropriate]
4. Type Tree ENTER [This will display the tree on the screen – just a test to see if you are in the correct directory, otherwise you can type: Dir and ENTER]
5. Type Tree /a /f > list ENTER [Tree*/a*/f*>*list ENTER – note “*” is a space. You can also type: tree/? To see an explanation of the codes. The “>” redirects the output from the screen to a file called “list” in the same directory]

You should now close the command prompt [click on X or type: Exit ENTER]

PS if you are not sure of the directory name, you can type dir /p ENTER after step 2.

You can now open the file in Notepad or in MSWord [It will be saved in the last directory that you tree-ed]

Praveen