ok, I remember this file now.
I'd asked about this last year, and got the same answer.
While I downloaded it, I never attempted to install it because of our strict
IT rules here. Pretty much makes our installing any programs moot.....
I just installed it and now cannot use the sample because of those same
restrictions.
Is there any other way to accomplish this goal?
To which, I'm guessing the response might be something along the lines of--
sure, how time, and learning do you want to go through......



"Jim Rech" wrote:

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