By the time you suggest, I have tested https://www.msofficeforums.com/vba/1...o-problem.html



is amazing to say, it works as per his needs

in my requirement it fits except

1. We dont need hyperlink but the value to be pasted instead of word file searched word,
2. Macro condition to ask whether to replace this word in word doc with excel value or not, if no move and search very next word text 1, in word file and replace ...till end,
3. Then it search for text 2(user input), in excel and again same as step 2,
4. and keep repeating steps till user cancel for no more.

This is my observation only, rest as you suggest.
--------


Nv