Hi!

I'm kind of reluctant to post this because it's "klunky"
but it will work to a certain extent. The data you get is
limited to that which is listed as "details" - file date
and time, size, file name with extension. I'm sure there's
a better way to do this through VBA and as soon as I post
this that better solution will appear!

Anyhow .... I've done this:

Open up a command prompt window and navigate to the
directory you're interested in.

Copy the contents of that dir to a text file. At the
command prompt type:

DIR FILE.TXT

Where FILE is any name you want to use.

Then copy the contents of that text file to a worksheet.
Edit out the stuff you don't want then use DataText to
Columns to parse out the info.

Sounds like a lot to go through but it only takes a couple
of minutes.

Biff

-----Original Message-----
Anybody know of a way to easily convert file name and
other file property
data such as modified date, path, size, type, etc. all
from a particular
directory and place the data into a spreadsheet where
each aspect would be in
it's own column?

Greatly appreciated. thanks.
.