Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching a Word Document from Excel
I am trying to write a Macro to be used in Excel that will search a number of
Word documents for certain words or phrases. This needs to work similar to the way you can do it when you use the Search for Files or Folder and fill in the "A Word or Phrase in the file" box. Does anyone know of any examples for this. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching a Word Document from Excel
Hi,
something along these lines: Sub Test455() Dim sPth As String Dim sNam As String Dim oWrd As Object sPth = "c:\test\word1\" Set oWrd = CreateObject("Word.Application") ' Set oWrd = GetObject(, "Word.Application") oWrd.Visible = True sNam = Dir(sPth & "*.doc") While sNam < "" oWrd.documents.Open sPth & sNam Dim rDcm As Object Set rDcm = oWrd.activedocument.Range With rDcm.Find .Text = "fox" While .Execute rDcm.Select Stop ' what now ? Wend End With oWrd.activedocument.Close sNam = Dir Wend oWrd.Quit Set oWrd = Nothing End Sub Which uses late binding, as early binding doesn't work here and now, due to a preconfigured chinese PC. See: http://word.mvps.org/FAQs/InterDev/E...ateBinding.htm See: http://word.mvps.org/faqs/interdev/C...WordFromXL.htm -- Greetings from Bavaria, Germany Helmut Weber, MVP WordVBA Vista Small Business, Office XP |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching a Word Document from Excel
Thanks. I will try that tomorrow. I'm sure with a little modification I can
get it to works for my needs.. Thanks for your help. "Helmut Weber" wrote: Hi, something along these lines: Sub Test455() Dim sPth As String Dim sNam As String Dim oWrd As Object sPth = "c:\test\word1\" Set oWrd = CreateObject("Word.Application") ' Set oWrd = GetObject(, "Word.Application") oWrd.Visible = True sNam = Dir(sPth & "*.doc") While sNam < "" oWrd.documents.Open sPth & sNam Dim rDcm As Object Set rDcm = oWrd.activedocument.Range With rDcm.Find .Text = "fox" While .Execute rDcm.Select Stop ' what now ? Wend End With oWrd.activedocument.Close sNam = Dir Wend oWrd.Quit Set oWrd = Nothing End Sub Which uses late binding, as early binding doesn't work here and now, due to a preconfigured chinese PC. See: http://word.mvps.org/FAQs/InterDev/E...ateBinding.htm See: http://word.mvps.org/faqs/interdev/C...WordFromXL.htm -- Greetings from Bavaria, Germany Helmut Weber, MVP WordVBA Vista Small Business, Office XP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert an Excel document to a Word Document | Setting up and Configuration of Excel | |||
change excel document into word document | Excel Discussion (Misc queries) | |||
Searching within an excel document | Excel Worksheet Functions | |||
convert excel document to word document (not a picture) | Excel Discussion (Misc queries) | |||
How to change a excel document into a word document? | Excel Discussion (Misc queries) |