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

 

[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

 

[Ron]

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.