Hello!
I've managed to work out how to use the replace function to change keywords in Word to whatever I've defined in a list in Excel. However, this does not seem to work when the text I want to replace in Word is in a textbox or shape.
I basically have a list of keywords in Excel with a list of their replacements in the next column. I want to cycle through each keyword in Excel, find it in Word and replace it with the replacement word listed in Excel. However, my Word document is written entirely in boxes, as it has a particular required layout. I cannot get Excel to replace the text in Word if it's in any kind of box. Can anyone offer any insight?
Many thanks
Bookmarks