![]() |
#2
|
||||
|
||||
![]()
It is not clear what your original macro is about with respect to calls to an unidentified macro, an added document and a named document, but the following will look in each text string marked <AFF>...</AFF>, and replace UK or U.K with "United Kingdom" and add a comment to that effect. UK or U.K not tagged with <AFF>...</AFF> are ignored.
Code:
Option Explicit Sub ChangeUK() Dim vFindText As Variant Dim sReplaceText As String Dim oRng As Range Dim oSearch As Range Dim oFound As Range Dim i As Long Dim sAsk As String vFindText = Array("UK", "U.K.") sReplaceText = "United Kingdom" Set oRng = ActiveDocument.Range With oRng.Find Do While .Execute(FindText:="\<AFF\>*\<\/AFF\>", MatchWildcards:=True) Set oSearch = oRng For i = 0 To UBound(vFindText) Set oFound = oSearch With oFound.Find .ClearFormatting .Replacement.ClearFormatting Do While .Execute(FindText:=vFindText(i), _ MatchWholeWord:=True, _ MatchWildcards:=True, _ Forward:=True, _ Wrap:=wdFindStop) = True oFound.Text = sReplaceText oFound.Comments.Add oFound, "Country name changed. Please check" oFound.Collapse wdCollapseEnd If oFound.End >= oSearch.End Then Exit Do Loop End With Next i Loop End With lbl_Exit: Exit Sub End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
Tags |
insert comment, vba macro |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
shilabrow | Excel Programming | 4 | 06-23-2014 08:16 AM |
Macro to insert Text | Morte | Excel Programming | 1 | 03-04-2014 04:33 PM |
![]() |
Sharon | Word | 5 | 01-29-2013 03:12 AM |
Macro to insert new page... | samanthaj | Word | 17 | 01-31-2012 01:53 PM |
![]() |
rfhall50 | Word VBA | 2 | 10-25-2010 12:41 PM |