1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
|
Function GetHyperlink( _
ByVal strLink As String, _
Optional ByVal hlpClearPrefix As HyperlinkPrefix _
= HyperlinkPrefix.none) As String
' Quelques variables
Dim strTemp As String
Dim intI As Integer
Dim intJ As Integer
' Position du premier #
strTemp = ""
intI = InStr(1, strLink, "#", vbTextCompare)
If intI > 0 Then
' Position du second #
intJ = InStr(intI + 1, strLink, "#", vbTextCompare)
If intJ > 0 Then
' Partie Adresse
strTemp = Trim(Mid(strLink, intI + 1, intJ - intI - 1))
' Suppression du mailto: si nécessaire
If ((hlpClearPrefix = HyperlinkPrefix.all) _
Or (hlpClearPrefix = HyperlinkPrefix.mailto)) _
And (LCase(Left(strTemp, 7)) = "mailto:") Then
strTemp = Mid(strTemp, 8)
End If
' Suppression du http:// si nécessaire
If ((hlpClearPrefix = HyperlinkPrefix.all) _
Or (hlpClearPrefix = HyperlinkPrefix.http)) _
And (LCase(Left(strTemp, 7)) = "http://") Then
strTemp = Mid(strTemp, 8)
End If
End If
End If
GetHyperlink = strTemp
End Function |
Partager