Extracting File Names and Properties

[Albacore33]

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.

[Biff]

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

[Biff]

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

[Ron]

"Albacore33" <Albacore33@discussions.microsoft.com> wrote in message
news:E70AEA3D-87E4-4249-83E3-502B42CE60C4@microsoft.com...
> 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.