Export list of file names from windows explorer

[Carlton Berry]

I am trying to export a list of file names displayed in
Windows Explorer so I can put them into an Excel
worksheet. The only thing I have found so far is to do a
screen print then rekey the file names. Surely there is a
better way.

 

[Willit]

This should

http://www.karenware.com/powertools/ptdirprn.asp

 

[Colin Painter]

Excellent, excellent question! This is one of the things that drive unix
nerds completely nuts about windows.

There may be a slicker way to do this but if I was doing this I would use
"DOS" and redirect the dir command to a file, and then import the result
into excel.

The DOS redirect looks like:

start>run cmd

and then in the dos window: dir/b > foo.txt

the file foo.txt can then be imported

cp

 

[Gord Dibben]

Colin

There is a better way.

Tushar Mehta(XL MVP) has written an Excel add-in that does just what you want
directly into Excel.

http://www.tushar-mehta.com/

Click on Directory List link.

Gord Dibben XL2002