Thread: [Solved] Format text automatically
View Single Post
 
Old 05-05-2013, 05:23 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote