Sorry Merjet

tried that...didn't work.

Michael Bond
-----Original Message-----
thnaks for the pointers in populating the two
columns...only one issue remaining....how do I pick up
on
the property attribute of the files themselves...that is
f1.Name gives me the name of the file but what do I need
to get the "subject" or "title" of the file....these are
normally set in the properties of the file in excel and
I
want to use them as the content for the second column

I've tried f1.Title and f1.Subject but both
return "object
does not support this"

Change your declare stmt for f1 to: Dim f1 as File
Then type 'f1.' and IntelliSense will show you your
options
are, although they probably not enough for you.

Merjet


.