Find and Replace in Word document from Excel macro

[r.vanmoorsel]

Hello,

I'm building a sheet to maken offers in Microsoft Word with data from Excel.
I would like to open a Word document from a Excel macro and find and replace all.
This code works, only I can find and replace more then one of the same text.

I already tried Replace:=wdReplaceAll but this doesn't work.
Someone has tips to get this working?

Please Login or Register  to view this content.

[mikerickson]

I'm not sure that Excel VBA would have access to Word's VBA constants. Try Replace:=2

[r.vanmoorsel]

Hi mikerickson,

Thanks voor your reaction!
I already tried 2 and 3.