Generate list of files and folders in text form

G

Guest

Windows Explorer easily displays a hierarchical display of files and folders.

However, I would like to generate such a list in text form, so I can get a
list of folders and/or file names into another program such as Word or
Excel, and/or print the list.

(As an awkward work-around, I could do a screen capture (Alt-PrintScreen)
and paste into Word, but that would only generate an image, which could be
printed but not accessed further. Also, a long list would require multiple
screen captures.)

Is there any way to get Windows Explorer to output to a text format, or some
other mechanism for generating a list of files in Word or Excel?

Thanks.
 
P

Pegasus \(MVP\)

Eric said:
Windows Explorer easily displays a hierarchical display of files and folders.

However, I would like to generate such a list in text form, so I can get a
list of folders and/or file names into another program such as Word or
Excel, and/or print the list.

(As an awkward work-around, I could do a screen capture (Alt-PrintScreen)
and paste into Word, but that would only generate an image, which could be
printed but not accessed further. Also, a long list would require multiple
screen captures.)

Is there any way to get Windows Explorer to output to a text format, or some
other mechanism for generating a list of files in Word or Excel?

Thanks.

The simplest way is to open a Command Prompt and type a command
of the form

dir /b "c:\documents and settings\Eric\My Documents" > c:\dir.txt

The list will then appear in the file c:\dir.txt.

To automate the process, have a look at this link:
http://support.microsoft.com/?kbid=321379
 
P

Poprivet

Eric said:
Windows Explorer easily displays a hierarchical display of files and
folders.

However, I would like to generate such a list in text form, so I can
get a list of folders and/or file names into another program such as
Word or Excel, and/or print the list.

(As an awkward work-around, I could do a screen capture
(Alt-PrintScreen) and paste into Word, but that would only generate
an image, which could be printed but not accessed further. Also, a
long list would require multiple screen captures.)

Is there any way to get Windows Explorer to output to a text format,
or some other mechanism for generating a list of files in Word or
Excel?

Thanks.

Well, from a Command Prompt, navigate to the folder you want details on and
enter:
DIR /s > mytext.txt

It'll create a text list of every folder and file in the current folder. If
you want the whole computer, do it from the C: root but it's a bit list!
<g>

Or, you could use something like jdirprin from
http://www.spadixbd.com/freetools/jdirprint.htm
or
it's probably available at places like pcmag.com and several others. It's
free, so don't pay for it.

Pop`

or any of hundreds of other sites. I can't find the original author's site
right now unfortunately.
 
M

Merlin

Eric said:
Windows Explorer easily displays a hierarchical display of files and
folders.

However, I would like to generate such a list in text form, so I can get a
list of folders and/or file names into another program such as Word or
Excel, and/or print the list.

(As an awkward work-around, I could do a screen capture (Alt-PrintScreen)
and paste into Word, but that would only generate an image, which could be
printed but not accessed further. Also, a long list would require
multiple
screen captures.)

Is there any way to get Windows Explorer to output to a text format, or
some
other mechanism for generating a list of files in Word or Excel?

Thanks.


Try this http://www.karenware.com/powertools/ptdirprn.asp
 
G

Gord Dibben

Eric

If you're still looking...............

Several methods to accomplish this.......I like Tushar's best if importing to
Excel.

To add a "Print Directory" feature to Explorer, go to
this KB Article.

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q272623&

Or you can download Printfolder 1.2 from.....

http://no-nonsense-software.com/freeware/

I use PF 1.2 and find it to be more than adequate with custom
features.

OR Go to DOS(Command) prompt and directory.
Type DIR >MYFILES.TXT

All the above create a *.TXT file which can be opened in Notepad or
Excel.

One more method if you want to by-pass the *.TXT file and pull
directly to Excel is to use Tushar Mehta's Excel Add-in. This allows filtering
and sorting once you have the data in Excel.

http://www.tushar-mehta.com/ scroll down to Add-ins>Directory
Listing.

Download the ZIP file and un-zip to your Office\Library folder.


Gord Dibben MS Excel MVP
 
G

Guest

My need for this type of printout it to check my directories and files to see
where I may have duplicated folders and files. Looking at Explorer on screen
does not give me enough of a visual picture and ideas on how to delete or
move files. So far I tried
<<<Try this http://www.karenware.com/powertools/ptdirprn.asp>>> from the
suggestions here. I found this very poor in giving instructions once the
program is downloaded. After a long time, I did manage to save the
directories, folders and files - about 66,000(!) so mayve this is not going
to work.

I want to try anyway and again the lack of instructions hurt since I cannot
find out how to import the resulting Text Files into Excel or Word. There I
thought there would be a way to not only see the files, but to sort them and
see all of the duplicates. I have two hard drives to do this on and it is not
going well.

Am I complicating my task or just not doing it correctly. So far I have the
text files of the C: and E: directories and could import neither into Word or
Excell.

Thanks for any further feedback on the subject.

George
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top