Function HTMLDecode(ByVal html As String) As String Dim i As Long HTMLDecode = html Do i = InStr(i + 1, HTMLDecode, "&") If i = 0 Then Exit Do
If StrComp(Mid$(HTMLDecode, i, 6), " ", vbTextCompare) = 0 Then HTMLDecode = Left$(HTMLDecode, i - 1) & " " & Mid$(HTMLDecode, i + 6) ElseIf StrComp(Mid$(HTMLDecode, i, 6), """, vbTextCompare) = 0 Then HTMLDecode = Left$(HTMLDecode, i - 1) & """" & Mid$(HTMLDecode, _ i + 6) ElseIf StrComp(Mid$(HTMLDecode, i, 5), "&", vbTextCompare) = 0 Then HTMLDecode = Left$(HTMLDecode, i - 1) & "&" & Mid$(HTMLDecode, _ i + 5) ElseIf StrComp(Mid$(HTMLDecode, i, 4), "<", vbTextCompare) = 0 Then HTMLDecode = Left$(HTMLDecode, i - 1) & "<" & Mid$(HTMLDecode, _ i + 4) ElseIf StrComp(Mid$(HTMLDecode, i, 4), ">", vbTextCompare) = 0 Then HTMLDecode = Left$(HTMLDecode, i - 1) & ">" & Mid$(HTMLDecode, _ i + 4) End If Loop End Function |