% '字段內網址加上聯接。 Function ToLink(Str) Dim RE '正則表達式對象 Dim strContent If IsNull(Str) Then Str = "" Set RE = New RegExp '創建正 則表達式對象 With RE .Global = True '搜索應用于整個字符串 .IgnoreCase = True '搜索不區分大小寫的 strContent = Str '*************************************************************** '郵件地址鏈接自動設置 '*************************************************************** .Pattern = "([\w]*)@([\w\.]*)" strContent = .Replace(strContent, "A Href='mailto:$1@$2'>$1@$2/A> ") '*************************************************************** '鏈接自動設置 '*************************************************************** '======根據要求再添加協議名稱======= Dim D(3), I D(0) = "http" D(1) = "ftp" D(2) = "news" D(3) = "mms" '=================================== For I = 0 To UBound(D) .Pattern = D(I) + ":\/\/([\w\.]*)" strContent = .Replace(strContent, "A Href='" + D(I) + "://$1' target=_blank>" + D(I) + "://$1/A> ") Next '*************************************************************** End With Set RE = Nothing ToLink = strContent End Function
