There are two ways to go on this I believe. You can either open each
workbook and read the document property using the workbook
BuiltinDocumentProperties property. Or you can use the Dsofile.dll file MS
has provided which can read the properties from a closed file but might
require a greater learning curve:

http://support.microsoft.com:80/kb/224351

--
Jim
"SteveDB1" wrote in message
...
| Hi all.
| I am interested in making a routine that will search the builtin document
| properties of an excel file.
|
| I've tried using the windows search tool for that in the past and it
doesn't
| go far enough. I can look for words, or phrases in a file, but nothing
else--
| unless I've missed something.
|
| The goal is to look in a directory where all of the files of interest are
| stored. The two properties that I want to search through are the Title,
and
| Comments.
|
| I'd have either two different routines- one for Title, and the other for
| Comments, or it'd be a single routine, with a check box to choose one of
the
| two. I can modify once I get a general form to work.
|
| I know that I'd need an application.inputbox to enter the title, or
comment
| contents I'm looking for.
|
| How would I accomplish this?
| Thank you in advance for your helps.
|