Find and Replace in Word document through Excel VBA

Hi guys,

I am trying to develop a code in Excel VBA that will collect all the data gathered through a Userform and then Find and Replace all that information in a dummy contract.

I have succesfully programmed all the Excel part of this process, however from some reason I cannot get Excel to Find and Replace in the Word document I specify.

Here's the code I have thus far for this bit of the process:

Please Login or Register  to view this content.

Any help will be appreciated!

Hi Tinbendr,

Thanks for pointing that out, although I still get the same error when running the code at exactly this point:

Please Login or Register  to view this content.

Any thoughts?

Thanks!

I just figured out a workaround for this, it is pretty basic but serves my needs.

I will leave it here for the rest of the community to see it and improve it:

Please Login or Register  to view this content.

Originally Posted by javi-xls

Hi Tinbendr,

Thanks for pointing that out, although I still get the same error when running the code at exactly this point:

Please Login or Register  to view this content.

Any thoughts?

Thanks!