Advertisement
Guest User

Untitled

a guest
Oct 18th, 2018
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.61 KB | None | 0 0
  1. Sub flexibeleofferte()
  2. '
  3. ' flexibeleofferte Macro
  4. '
  5. '
  6. Selection.Find.ClearFormatting
  7. Selection.Find.Font.Size = 10.5
  8. Selection.Find.Replacement.ClearFormatting
  9. With Selection.Find
  10. .Text = "+0,00+"
  11. .Replacement.Text = ""
  12. .Forward = True
  13. .Wrap = wdFindContinue
  14. .Format = True
  15. .MatchCase = False
  16. .MatchWholeWord = False
  17. .MatchWildcards = False
  18. .MatchSoundsLike = False
  19. .MatchAllWordForms = False
  20. End With
  21. Selection.Find.Execute Replace:=wdReplaceAll
  22. With Selection.Find
  23. .Text = ",0000+"
  24. .Replacement.Text = ""
  25. .Forward = True
  26. .Wrap = wdFindContinue
  27. .Format = True
  28. .MatchCase = False
  29. .MatchWholeWord = False
  30. .MatchWildcards = False
  31. .MatchSoundsLike = False
  32. .MatchAllWordForms = False
  33. End With
  34. Selection.Find.Execute Replace:=wdReplaceAll
  35. With Selection.Find
  36. .Text = ",000+"
  37. .Replacement.Text = ""
  38. .Forward = True
  39. .Wrap = wdFindContinue
  40. .Format = True
  41. .MatchCase = False
  42. .MatchWholeWord = False
  43. .MatchWildcards = False
  44. .MatchSoundsLike = False
  45. .MatchAllWordForms = False
  46. End With
  47. Selection.Find.Execute Replace:=wdReplaceAll
  48. With Selection.Find
  49. .Text = ",00+"
  50. .Replacement.Text = ""
  51. .Forward = True
  52. .Wrap = wdFindContinue
  53. .Format = True
  54. .MatchCase = False
  55. .MatchWholeWord = False
  56. .MatchWildcards = False
  57. .MatchSoundsLike = False
  58. .MatchAllWordForms = False
  59. End With
  60. Selection.Find.Execute Replace:=wdReplaceAll
  61. With Selection.Find
  62. .Text = ",0+"
  63. .Replacement.Text = ""
  64. .Forward = True
  65. .Wrap = wdFindContinue
  66. .Format = True
  67. .MatchCase = False
  68. .MatchWholeWord = False
  69. .MatchWildcards = False
  70. .MatchSoundsLike = False
  71. .MatchAllWordForms = False
  72. End With
  73. Selection.Find.Execute Replace:=wdReplaceAll
  74. With Selection.Find
  75. .Text = "+0+"
  76. .Replacement.Text = ""
  77. .Forward = True
  78. .Wrap = wdFindContinue
  79. .Format = True
  80. .MatchCase = False
  81. .MatchWholeWord = False
  82. .MatchWildcards = False
  83. .MatchSoundsLike = False
  84. .MatchAllWordForms = False
  85. End With
  86. Selection.Find.Execute Replace:=wdReplaceAll
  87. With Selection.Find
  88. .Text = "+"
  89. .Replacement.Text = ""
  90. .Forward = True
  91. .Wrap = wdFindContinue
  92. .Format = True
  93. .MatchCase = False
  94. .MatchWholeWord = False
  95. .MatchWildcards = False
  96. .MatchSoundsLike = False
  97. .MatchAllWordForms = False
  98. End With
  99. Selection.Find.Execute Replace:=wdReplaceAll
  100. With Selection.Find
  101. .Text = "*0,00*"
  102. .Replacement.Text = ""
  103. .Forward = True
  104. .Wrap = wdFindContinue
  105. .Format = True
  106. .MatchCase = False
  107. .MatchWholeWord = False
  108. .MatchWildcards = False
  109. .MatchSoundsLike = False
  110. .MatchAllWordForms = False
  111. End With
  112. Selection.Find.Execute Replace:=wdReplaceAll
  113. With Selection.Find
  114. .Text = "*"
  115. .Replacement.Text = ""
  116. .Forward = True
  117. .Wrap = wdFindContinue
  118. .Format = True
  119. .MatchCase = False
  120. .MatchWholeWord = False
  121. .MatchWildcards = False
  122. .MatchSoundsLike = False
  123. .MatchAllWordForms = False
  124. End With
  125. Selection.Find.Execute Replace:=wdReplaceAll
  126. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement