Function InsertHyperlinks(inText)
Dim objRegExp, strBuf
Dim objMatches, objMatch
Dim Value, ReplaceValue, iStart, iEnd
ÃÂ strBuf = “”
ÃÂ iStart = 1
ÃÂ iEnd = 1
ÃÂ Set objRegExp = New RegExp
àobjRegExp.Pattern = “\b(www|http|\S+@)\S+\b”àxml:namespace prefix = o ns = “urn:schemas-microsoft-com:office:office” /??
‘ å¤æÂÂURLsÃ¥ÂÂemails.
ÃÂ objRegExp.IgnoreCase = TrueÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ
‘ 设置大å°ÂÃ¥ÂÂä¸ÂæÂÂæÂÂ..
ÃÂ objRegExp.Global = TrueÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ
‘ Ã¥Â
¨å±ÂéÂÂç¨.
ÃÂ Set objMatches = objRegExp.Execute(inText)
ÃÂ For Each objMatch in objMatches
ÃÂ ÃÂ iEnd = objMatch.FirstIndex
ÃÂ ÃÂ strBuf = strBuf & Mid(inText, iStart, iEnd-iStart+1)
ÃÂ ÃÂ If InStr(1, objMatch.Value, “@”) Then
ÃÂ ÃÂ ÃÂ strBuf = strBuf & GetHref(objMatch.Value, “EMAIL”, “_BLANK”)
ÃÂ ÃÂ Else
ÃÂ ÃÂ ÃÂ strBuf = strBuf & GetHref(objMatch.Value, “WEB”, “_BLANK”)
ÃÂ ÃÂ End If
ÃÂ ÃÂ iStart = iEnd+objMatch.Length+1
ÃÂ Next
ÃÂ strBuf = strBuf & Mid(inText, iStart)
ÃÂ InsertHyperlinks = strBuf
End Function
Function GetHref(url, urlType, Target)
Dim strBuf
ÃÂ strBuf = “<a href=”””
ÃÂ If UCase(urlType) = “WEB” Then
ÃÂ ÃÂ If LCase(Left(url, 3)) = “www” Then
àààstrBuf = “<a href=””URL:” & url & “””è¶Â
级é¾æÂÂ¥:””” & _
ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ Target & “””>” & url & “</a>”
ÃÂ ÃÂ Else
àààstrBuf = “<a href=””” & url & “””è¶Â
级é¾æÂÂ¥:””” & _
ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ Target & “””>” & url & “</a>”
ÃÂ ÃÂ End If
ÃÂ ElseIf UCase(urlType) = “EMAIL” Then
ààstrBuf = “<a href=””çµåÂÂé®件å°åÂÂ:” & url & “””é¾æÂ¥ç®æ Â:””” & _
ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ Target & “””>” & url & “</a>”
ÃÂ End If
ÃÂ GetHref = strBuf
End Function
ÃÂ
ÃÂ
[1]