Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Showing Search results in msgbox?
I have links to a batch of Word files in my spreadsheet. I'm trying to
create a macro that will let my users use the OpenToolsFind search function to search all the files for documents containing certain words or phrases. My only problem is that I can't figure out how to save the search results in a string to show in a message box when the search is complete. (There's reasons why I would prefer to do the message box rather than giving them the Open Files window, if it's possible.) Any suggestions are appreciated. Ed |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Showing Search results in msgbox?
Thank you, Tom!
Ed "Tom Ogilvy" wrote in message ... Use the filesearch object. this returns .FoundFiles you can then do for i = 1 to .Foundfiles.count msgbox .foundFiles(i) Next There is a good code example in the Excel VBA help files. -- Regards, Tom Ogilvy "Ed" wrote in message ... I have links to a batch of Word files in my spreadsheet. I'm trying to create a macro that will let my users use the OpenToolsFind search function to search all the files for documents containing certain words or phrases. My only problem is that I can't figure out how to save the search results in a string to show in a message box when the search is complete. (There's reasons why I would prefer to do the message box rather than giving them the Open Files window, if it's possible.) Any suggestions are appreciated. Ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search formula showing results plus 100 characters | Excel Discussion (Misc queries) | |||
IF formula only showing positive results | Excel Discussion (Misc queries) | |||
Showing results in cell using formulas | Excel Discussion (Misc queries) | |||
Formulas not showing results | Excel Worksheet Functions | |||
MsgBox with condition and showing details | Excel Worksheet Functions |