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