Hi Nancy,



As I have said, there are different ways of updating your document.
Until you tell me more about how you are using the document, I am reluctant to give you a solution that might be done more efficiently another way.
The macro in this link https://www.msofficeforums.com/vba/1...o-problem.html shows how one might go about updating a Word document from an Excel file. It would need some changes before it could be used for your purposes but, as I've already said, there may be a better way. Some 80% of the code in that link is needed just to manage Excel.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I tried downloading that excel and doc but that are in xlsx and docx format so cant open that and see, but the issues could be solved like this, but here I have doubt once the link is not there , wont the replace changes again into original?

I am attaching both files for your reference, where test 1....test 3 etc are need to be worked upon,

Here to make it use ABLE for any find and replace text, macro should ask the text first, and while coping and pasting again in word from excel, it must ask if that is required word, else find next and replace with corresponding value,

Attached Files

	Book1.xls (13.5 KB, 9 views)
	test.doc (19.5 KB, 9 views)