windows explorer to excel

B

barrfly

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

Earl Kiosterud

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