Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |