Hi Experts,

I want to replace excel cell value in ms word file.... if Excel Column A value is present in ms word document then replace word doc value with Excel Column B with sort name of Column A

As.. range A3 = Visual Basic and column B3 = VBA then will replace in ms word doc all "Visual Basic" keyword with "VBA" keyword with background yellow color in ms word..

if same word like "Visual Basic" is many times in ms word then all words replace with "VBA" word with yellow color but the first number of replaced word will be in read color back ground color in ms word file.....

Please find attached my excel macro file which i have developed ...

Pelase change the code for the same

my excel VBA password is----------------- kk

This is really urget... Pelase help me....

Attached Files

	Macro.xls (47.0 KB, 38 views)
	Doc1.doc (25.5 KB, 33 views)