windows explorer to excel
 

I know this is not excel specific, but does anyone know a good way to
export the file names and properties of a folder in windows explorer to
an excel file? For example, I want to create a CSV file that has in
it's columns the file name, file size, type, date modified, etc. I
would imagine that there would be a utility in windows explorer, but i
have looked with no success. Is there an aftermarket product that will
do that?


--
barrfly

Excel User - Energy markets
------------------------------------------------------------------------
barrfly's Profile: http://www.excelforum.com/member.php...fo&userid=4141
View this thread: http://www.excelforum.com/showthread...hreadid=390576

barrfly,

Try it at the command line (Start - Programs - cmd.exe). Long-toothed folks
will call it "DOS." :) Once there, try something like

DIR myfile.txt

Type exit at the command line, or click the X, when you're done with the
"DOS box."

Pay attention to the path (C:\Documents and Settings\ etc.) -- that
determines the folder where the file will be written to. myfile.txt should
exist after running the DIR command above. It won't be comma-delimited, but
you could open it with Excel and get it converted to a proper
comma-delimited file, if necessary.
--
Earl Kiosterud
www.smokeylake.com

"barrfly" wrote in
message ...

I know this is not excel specific, but does anyone know a good way to
export the file names and properties of a folder in windows explorer to
an excel file? For example, I want to create a CSV file that has in
it's columns the file name, file size, type, date modified, etc. I
would imagine that there would be a utility in windows explorer, but i
have looked with no success. Is there an aftermarket product that will
do that?


--
barrfly

Excel User - Energy markets
------------------------------------------------------------------------
barrfly's Profile:
http://www.excelforum.com/member.php...fo&userid=4141
View this thread: http://www.excelforum.com/showthread...hreadid=390576

I came across this a few months ago. Hope it Helps

http://tinyurl.com/czf6f

Odie


--
Odicus
------------------------------------------------------------------------
Odicus's Profile: http://www.excelforum.com/member.php...o&userid=25610
View this thread: http://www.excelforum.com/showthread...hreadid=390576