从超链接对象中获取.Address
和可选的.SubAddress
实际上是一种相当简单的方法。 .TextToDisplay
属性仅是单元格的值或文本。
Sub html_anchors()
Dim a As Range, u As String, l As String
Dim sANCHOR As String: sANCHOR = "<a href=""%U%"">%L%</a>"
For Each a In Selection
With a
If CBool(.Hyperlinks.Count) Then
l = .Text
u = .Hyperlinks(1).Address
If Right(u, 1) = Chr(47) Then u = Left(u, Len(u) - 1)
.Hyperlinks(1).Delete
.Value = Replace(Replace(sANCHOR, "%U%", u), "%L%", l)
End If
End With
Next a
End Sub
选择要处理的所有单元格,然后运行程序。如果您选择的任何单元格中没有包含超链接,它将被忽略。
http://
需要一个双斜杠。给我一点时间…… - user4039065