To replace watermark in word using excel

[priyamvada]

I wrote an excel macro which will open and embedded word doc inside the excel and replace text,header ,footer and all with cell values user input in excel and save as a new doc in a local folder of the user.
I want to replace the existing watermark inside the document/insert a new watermark based on the input given in excel sheet. Please help.For finding and replacing ,i have used the below code

For Each MyRange In wrdDoc.StoryRanges
With MyRange.Find
.Text = "<<Document Name>>"
.Replacement.Text = DocName
.Wrap = wdFindContinue
.Execute Replace:=wdReplaceAll
End With
Loop

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

This is your second warning about the same rules in your first two posts. Either read & follow the Forum Rules or don't post