This may not sound easy but I have this nice little conversion routine that was written by EE Pros. When I have this on one computer it works great. When I copy it and put it on another computer, I get a error in this module:
Public Sub GetExchangeRate(strHTML As String)
and the error on this line:
Range(strRangeName).Value = IIf(IsNumeric(Mid(strTemp,
1, InStr(1, strTemp, "<", vbTextCompare) - 1)) = True, Mid(strTemp, 1, InStr(1, strTemp, "<", vbTextCompare) - 1), 1)
I have been trying to trouble shoot this but am not having any luck.
Help! Thanks in advance.......