想用宏替换掉文章内的某一种颜色的字体,例如颜色RGB(221,221,221),试了很多次录制宏不能被执行,所以求做一段用手编的VBA程序。或者能录制成功也行。现提供下我录制生成的代码,给分析下不能执行的原因。
Sub Macro1()
'
' Macro1 Macro
' 宏在 2013-8-6 由 USER 录制
'
Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = ""
.Replacement.Text = ""
.Forward = True
.Wrap = wdFindContinue
.Format = True
.MatchCase = False
.MatchWholeWord = False
.MatchByte = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
End Sub
能不能再改一下,我要的是把替换的字删除掉,还有能不能把要删除字的颜色RGB(221,221,221)写进去。
追答把前面这部分代码
Sub ColorReplace()
Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
Selection.Find.Font.Color = wdColorRed
Selection.Find.Replacement.Font.Color = wdColorBlue
改成:
Sub ColorReplace()
Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
Selection.Find.Font.Color = RGB(221,221,221)