![]() |
|
|
|
#1
|
|||
|
|||
|
I have tried using wild cards but its throwing lots of errors because of special characters
such as word ending with > |
|
#2
|
|||
|
|||
|
Distortion using wildcard.zip
I have tried using wildcards but getting error i have attached the error snap shot I have attached the macro, word file and excel file Code:
Sub RemoveShreeLipiDistortionUsingWildCards()
Dim objExcel As Object
Set objExcel = CreateObject("Excel.Application")
Set exWb = objExcel.Workbooks.Open(ActiveDocument.path + "\List of ShreeLipi Distortion (1).xlsx")
Dim counter As Integer
counter = 1000 'exWb.Worksheets(1).Rows.Count
Dim i As Integer
Dim oRng As Range
'For i = 250 To counter
For i = 2 To counter
If exWb.Worksheets(1).Range("A" & i) = "" Then
Exit For
End If
Set oRng = ActiveDocument.Range
With oRng.Find
.Text = "<" + Replace(exWb.Worksheets(1).Range("A" & i), "^", "^^") + ">"
.Replacement.Text = Replace(exWb.Worksheets(1).Range("B" & i), "^", "^^")
.MatchCase = True
'.MatchWholeWord = True
.MatchWildcards = True
.MatchCase = True
.Execute Replace:=wdReplaceAll
End With
Next i
exWb.Close
Set exWb = Nothing
Set objExcel = Nothing
End Sub
Last edited by macropod; 05-17-2017 at 10:38 PM. Reason: Added code tags |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
MS Word 2016 Find and Replace
|
BillM | Word | 2 | 03-14-2017 10:49 AM |
Need help using Find & Replace (MS Word)
|
BZee | Word | 9 | 02-16-2015 05:45 PM |
| Replace each heading with a unique numeric value | amitkapoor | Word | 7 | 05-06-2013 03:29 AM |
Word Find and Replace Query
|
bthart | Word | 1 | 12-29-2011 12:45 AM |
Bad view when using Find and Find & Replace - Word places found string on top line
|
paulkaye | Word | 4 | 12-06-2011 11:05 PM |