![]() |
#20
|
||||
|
||||
![]()
Doing all this stuff makes the macro much more complicated:
Code:
Sub Test() Application.ScreenUpdating = False Dim i As Long With ActiveDocument.Range With .Find .ClearFormatting .Replacement.ClearFormatting .Forward = True .Wrap = wdFindStop .MatchWildcards = True .Text = "[^13]{2,}" .Replacement.Text = "^p" .Execute Replace:=wdReplaceAll .Text = "^13D[AO][S ]{1,2}VEREADOR*^13" .Replacement.Text = "" .Execute End With Do While .Find.Found .Start = .Start + 1 Do While .Paragraphs.Last.Next.Range.Font.Bold = False And .Paragraphs.Last.Next.Range.End <> ActiveDocument.Range.End .MoveEnd wdParagraph, 1 Loop For i = .Paragraphs.Count To 2 Step -1 If Not .Paragraphs(i).Range.Text Like "Nº #*" Then If Not .Paragraphs(i).Range.Text Like "D[AO][S ]*VEREADOR*" Then .Paragraphs(i).Range.Characters.First.Previous = " " End If Next .Collapse wdCollapseEnd .Find.Execute Loop With .Find .Forward = True .Wrap = wdFindContinue .MatchWildcards = True .Text = "[^13]" .Replacement.Text = "^p^p" .Execute Replace:=wdReplaceAll .Text = "(^13D[AO][S ]{1,2}VEREADOR*)[^13]{1,}" .Replacement.Text = "\1^p" .Execute Replace:=wdReplaceAll End With End With With ActiveDocument.Range While .Characters.Last.Previous.Text = vbCr .Characters.Last.Previous.Text = vbNullString Wend End With Application.ScreenUpdating = True End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro to find text in between two characters and then format selected text? | qcom | Word | 5 | 02-19-2015 11:23 PM |
automatically format meetings by me with some attendee | wsw70 | Outlook | 0 | 06-24-2011 12:16 AM |
Objective: Automatically export email text,attachment text to DB friendly format | SilentLee | Outlook | 0 | 11-14-2010 02:45 PM |
automatically extract footnotes into new file and apply character format to footnote | hrdwa | Word | 0 | 02-27-2010 03:16 AM |
format cells to automatically place quotes around text | dirtleg | Excel | 1 | 09-16-2008 01:52 PM |