![]() |
#16
|
|||
|
|||
![]() Views: 11 Size: 48.4 KB">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 |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
BillM | Word | 2 | 03-14-2017 10:49 AM |
![]() |
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 |
![]() |
bthart | Word | 1 | 12-29-2011 12:45 AM |
![]() |
paulkaye | Word | 4 | 12-06-2011 11:05 PM |