View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected][_2_] paulquinlan100@hotmail.com[_2_] is offline
external usenet poster
 
Posts: 7
Default "method 'execute' of object 'find' failed"

Hi

I have a bit of code that takes information from an excel sheet and
sends it to a template in Word. Its essentially a big list of find and
replace commands. It mostly works fine however, occiasionally i get
the error message "method 'execute' of object 'find' failed" and from
then on (it works for the first half of the document and always stops
in the same place) the find/replace commands will not work. the bit of
code it always fails on is:

With .Content.Find
.Text = "Iaootherbidders"
.Replacement.Text = Others
.Forward = True
.Execute Replace:=wdReplaceOne
End With

but there are a large number of other similar statements preceeding
this that work fine. Any ideas what could be causing this problem?

Thanks for any suggestions
Paul