only recognizes if HTTP is passed.. but it's a start!
Dan
Code:
function ConstructLink(strString)
' see if we need to do anything
if instr(1,strString,"http://",vbTextCompare) > 0 then
'make it a link
dim newstring, startpos, endpos, URL
' find positions of URL
startpos = instr(1,strString,"http://",vbTextCompare)
endpos = instr(startpos+1,strString," ",vbTextCompare)
if endpos = 0 then
endpos = len(strString)
URL = mid(strString,startpos,(endpos-startpos+1))
newstring = left(strString,startpos-1)
newstring = newstring & "<a target=""_blank"" href=""" & URL & """>" & URL & "</a>"
newstring = newstring & right(strString,len(strString)-endpos)
else
URL = mid(strString,startpos,(endpos-startpos))
newstring = left(strString,startpos-1)
newstring = newstring & "<a target=""_blank"" href=""" & URL & """>" & URL & "</a>"
newstring = newstring & right(strString,len(strString)-endpos+1)
end if
ConstructLink = newstring
else
' just return the value
ConstructLInk = strString
end if
end function
Bookmarks