Extracting File Names and Properties
 

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.

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

See, I knew it!

as soon as I post this that better solution will appear!

See your other post in .MISC.

Jim Cone has an add-in to do this.

Biff

-----Original Message-----
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.
.

.

"Albacore33" wrote in 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.

If you have Outlook installed, navigate to the folder in question using
Outlook and then just copy and paste into Excel. It works like a charm.