![]() |
|
#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 |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
How to Insert more criteria in Macro
|
shilabrow | Excel Programming | 4 | 06-23-2014 08:16 AM |
| Macro to insert Text | Morte | Excel Programming | 1 | 03-04-2014 04:33 PM |
Macro to insert picture in footer
|
Sharon | Word | 5 | 01-29-2013 03:12 AM |
| Macro to insert new page... | samanthaj | Word | 17 | 01-31-2012 01:53 PM |
Macro for Picture Insert
|
rfhall50 | Word VBA | 2 | 10-25-2010 12:41 PM |