用word的宏进行批量添加超链接
想在word里进行一些重复性的工作
一直人工复制粘贴太傻了
宏简直不要太好用,能做一些一些重复机械性的操作
本段代码是用于给某些文字添加超链接,顺便还可以修改显示的字符
上代码:
Sub AddHyperlink()
'
' AddHyperlink 宏
' 批量添加超链接
'
Selection.Find.ClearFormatting
Dim i
For i = 1 To 500
With Selection.Find
.Text = "*xxxxxxx要替换的内容*"
.Replacement.Text = ""
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchByte = True
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
Selection.Find.Execute
ChangeFileOpenDirectory _
"*xxxword文件所在位置*"
ActiveDocument.Hyperlinks.Add Anchor:=Selection.Range, Address:= _
"*xx要替换的超链接*", SubAddress:="", ScreenTip:="", TextToDisplay:= _
"*xxx显示字符*", Target:="_blank"
Next i
End Sub