Start a document search from word or VBA

How can I invoke a document search form either a document or a VBA macro?

I have an application where I generate multiple documents
(.doc,.xls,.pdf,etc.) all saved on \mydocuments\various folders. All file
names start with (or contain) a unique claim number. To find all documents
related to a claim, I now show the desktop, click on a "my documents" folder,
hit the search icon and put the claim number in the file name fill-in.

I have VAB code that creates a claim controling Word.doc from corporate web
page data (I mine the web page data to prefill some note templates specific
to our office) and I insert claim data into a claim_log.xls.

I would like to embed a one button document search for this claim in the
word doc (hyperlink or a macro button-passing a claim number paramater) or in
the claim log.xls This method needs to become part of the VBA that creates
the claim.doc/Claim_log.xls entry.

I think what I want to launch is the Search Companion (we are running XP)
but I don't know the syntax and how to pass parameters to it or the best way
(or any way) to launch to search for files with a specific file name.
--
Bruce Mathews
Trying to master VBA

See the article "Insert into a document the names of all files in a selected
folder" at:

http://www.word.mvps.org/FAQs/MacrosVBA/InsertFileNames.htm

Use an InputBox to get the claim number and use an If...EndIf construction
to test for the presence of the claim number in each file that is accesses
by the routine, only inserting the filename if the condition is met.
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Bruce Mathews" <brucelmathews DeleteThis @yahoo.com(donotspam)> wrote in message
news:6D823145-A723-4ED3-8D43-401F1B0691AA@microsoft.com...
> How can I invoke a document search form either a document or a VBA macro?
>
> I have an application where I generate multiple documents
> (.doc,.xls,.pdf,etc.) all saved on \mydocuments\various folders. All file
> names start with (or contain) a unique claim number. To find all
> documents
> related to a claim, I now show the desktop, click on a "my documents"
> folder,
> hit the search icon and put the claim number in the file name fill-in.
>
> I have VAB code that creates a claim controling Word.doc from corporate
> web
> page data (I mine the web page data to prefill some note templates
> specific
> to our office) and I insert claim data into a claim_log.xls.
>
> I would like to embed a one button document search for this claim in the
> word doc (hyperlink or a macro button-passing a claim number paramater) or
> in
> the claim log.xls This method needs to become part of the VBA that
> creates
> the claim.doc/Claim_log.xls entry.
>
> I think what I want to launch is the Search Companion (we are running XP)
> but I don't know the syntax and how to pass parameters to it or the best
> way
> (or any way) to launch to search for files with a specific file name.
> --
> Bruce Mathews
> Trying to master VBA