Sub A4加下划线()
Dim St$, i&, j&
St = [A4]
i = InStr(1, St, "我单位已完成了")
j = InStr(i, St, "工作")
With [A4].Characters(Start:=i + 7, Length:=j - i - 7).Font
.Underline = xlUnderlineStyleSingle
End With
i = InStr(j, St, "附件:")
j = InStr(i, St, "复核记录表")
With [A4].Characters(Start:=i + 3, Length:=j - i - 3).Font
.Underline = xlUnderlineStyleSingle
End With
End Sub
追问这是单个文件加下划线吗?怎么去遍历多个文件?有几百个文件,就是不想每个文件的去打开,我把要处理的文件放一个目录里,可以去遍历后自动加下划线吗?