Replacing a string from one doc to another doc

macropod · #4 02-25-2020, 12:24 AM

Done correctly, it works. Without actually seeing your two documents, I can't be sure what it is you've done.
If, as I suspect, your table is as per the OP's 'Fixed version (replacing document).docx ' attachment (which isn't actually the fixed version), you need to change:

Code:

      .Text = Split(Tbl.Cell(r, 2).Range.Text, vbCr)(0)
      .Replacement.Text = Split(Tbl.Cell(r, 3).Range.Text, vbCr)(0)

to:

Code:

      .Text = Split(Tbl.Cell(r, 1).Range.Text, vbCr)(0)
      .Replacement.Text = Split(Tbl.Cell(r, 2).Range.Text, vbCr)(0)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Wildcard replace any string in context with a specified string	wardw	Word	7	05-07-2018 09:13 AM
How can I compare a string in a cell to another string?	Amitti	Word VBA	2	04-10-2017 07:35 PM
How to find all string within string.	PRA007	Word VBA	18	02-12-2016 08:11 PM
Way to search for a string in text file, pull out everything until another string?	omahadivision	Excel Programming	12	11-23-2013 12:10 PM
Replacing text string within document, it's not retaining formatting	livemusic	Word	4	02-25-2013 12:33 AM