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