Quote:
Do the data in your Excel workbook always update the same locations in the Word document? For example, does the value in B1 always replace 'test 1' in the Word document? If so, you don't need a macro.
Quote:
Originally Posted by nancy v
yes it is like that, but we need to see that while replacing macro ask if that is the only value we need to replace , else look for the next word "test 1" and replace it with a confirmation.
|
|
In that case, you probably don't need a Find/replace macro. What would probably suit your needs better is to link the data. To set up the link, all you need to do is to copy a given cell in Excel, switch to Word, then use Edit|Paste Special, click on the 'paste link' option and choose whichever of the paste formats you prefer. From then on, whenever you update the value in Excel, it will update in Word.