Thx Rajpes for that idea too. I will put that ion my bag of tricks to use in the future.
My issue is that I have all types of funny/different characters in my links. So, I found Replace.
My issue is that I have all types of funny/different characters in my links. So, I found Replace.
Code:
Public Function NormalizeString (OrgStr)
Dim TempStr
TempStr = Replace(OrgStr, "\", "\\")
TempStr = Replace(OrgStr, "/", "\/")
TempStr = Replace(TempStr, "*", "\*")
TempStr = Replace(TempStr, "+", "\+")
TempStr = Replace(TempStr, "(", "\(")
TempStr = Replace(TempStr, ")", "\)")
TempStr = Replace(TempStr, "=", "\=")
TempStr = Replace(TempStr, "&", "\&")
TempStr = Replace(TempStr, "@", "\@")
TempStr = Replace(TempStr, "#", "\#")
TempStr = Replace(TempStr, "_", "\_")
TempStr = Replace(TempStr, "!", "\!")
NormalizeString = Replace(TempStr, "?", "\?")
End Function