![]() |
#29
|
||||
|
||||
![]()
Try the following:
Code:
Sub Reformat() Application.ScreenUpdating = False Dim i As Long, RngFnd As Range With ActiveDocument Set RngFnd = .Range With .Range With .Find .ClearFormatting .Replacement.ClearFormatting .Forward = True .Wrap = wdFindStop .MatchWildcards = True .Text = "[^13]{1,}D[ao][s ]{1,2}Vereador*^13" .Replacement.Text = "" .Execute End With RngFnd.Start = .Start + 1 End With With RngFnd With .Find .ClearFormatting .Replacement.ClearFormatting .Forward = True .Wrap = wdFindStop .MatchWildcards = True .Text = "[^13]{1,}" .Replacement.Text = "^p^p" .Execute Replace:=wdReplaceAll .Text = "[ ]{1,}^13" .Replacement.Text = "^p" .Execute Replace:=wdReplaceAll .Text = "[^13]{1,}(D[ao][s ]{1,2}Vereador*)([^13]{1,})" .Replacement.Text = "^p\1^l" .Execute Replace:=wdReplaceAll .Text = "[^13]{1,}(Nº)" .Replacement.Text = "^p^l\1" .Execute Replace:=wdReplaceAll .Text = "[^13]{1,}(MATÉRIA DO LEGISLATIVO)[^13]{1,}" .Replacement.Text = "^p^l\1^l^p" .Execute Replace:=wdReplaceAll .Text = "[^13]{1,}(INDICAÇÕES)[^13]{1,}" .Replacement.Text = "^p^l\1^l^p" .Execute Replace:=wdReplaceAll .Text = "[^13]{1,}(MOÇÕES)[^13]{1,}" .Replacement.Text = "^p^l\1^l^p" .Execute Replace:=wdReplaceAll .Text = "[^13]{2,}" .Replacement.Text = " " .Execute Replace:=wdReplaceAll .Text = "^l" .Replacement.Text = "^p" .Execute Replace:=wdReplaceAll .Text = "[^13]{1,}(D[ao][s ]{1,2}Vereador*)([^13]{1,})" .Replacement.Text = "^p^p\1^p" .Execute Replace:=wdReplaceAll End With End With 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 |