![]() |
|
#1
|
|||
|
|||
![]()
Another issue. I'm using wildcards in the script but it's not working, see below. I've added MatchWildcards:=True, _ runs without errors but replaces with actual characters.
Sub Punctuation() Dim vFindText As Variant Dim vReplaceText As Variant Dim oRng As Range Dim i As Long vFindText = Array(":^tSO ", ". SO ", "? SO ", "WORKERS COMPENSATION", "WORKERS COMP", "WORKER'S COMPENSATION", "WORKER'S COMP") vReplaceText = Array(":^tSO, ", ". SO, ", "? SO, ", "WORKERS' COMPENSATION", "WORKERS' COMP", "WORKERS' COMPENSATION", "WORKERS' COMP") For i = 0 To UBound(vFindText) Set oRng = ActiveDocument.Range With oRng.Find .ClearFormatting .Replacement.ClearFormatting Do While .Execute(findText:=vFindText(i), _ MatchWholeWord:=True, _ Forward:=True, _ MatchWildcards:=True, _ Wrap:=wdFindStop) = True oRng.Text = vReplaceText(i) oRng.Collapse wdCollapseEnd Loop End With Next lbl_Exit: Set oRng = Nothing Exit Sub End Sub |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
alex100 | Word VBA | 5 | 07-08-2020 04:14 AM |
![]() |
Surge | Word | 6 | 03-10-2020 12:42 AM |
![]() |
kvnrao | Word VBA | 7 | 11-02-2018 06:28 PM |
![]() |
mauuuuu5 | Word | 1 | 08-23-2015 09:20 PM |
![]() |
kjxavier | Word | 1 | 01-02-2015 12:15 AM |