Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA error: "object doesn't support this property or method" | Excel Discussion (Misc queries) | |||
Run-time error "1004" Select method of range class failed | Excel Discussion (Misc queries) | |||
Method 'Range' of object '_global' failed | Excel Discussion (Misc queries) | |||
Method 'MailEnvelope' of object '_Worksheet' failed | Excel Discussion (Misc queries) | |||
Method 'Paste' of object '_Worksheet' failed | Excel Discussion (Misc queries) |