Hi guys,

I'm trying to get a csv / text result file from one of our internal servers. Normally web scraping doesn't pose much of a challenge for me, but this one has got me stumped.

When doing the standard way as below, I get the following error when trying to process the responsetext: "Run-time error "-2147023783 (80070459": No Mapping for the Unicode character exists in the target multi-byte code page."

With CreateObject("WinHTTP.WinHTTPRequest.5.1")
.Open "GET", url
.SetAutoLogonPolicy 0
.Send

debug.print .responsetext
When stopping redirections and getting the security / SSO cookies on each step as below, it doesn't help - the run time error doesn't show anymore, but now it gives me: Run-time error '438', object doesn't support this property or method.
With CreateObject("WinHTTP.WinHTTPRequest.5.1")
.Option(6) = False
.Open "GET", url
.SetAutoLogonPolicy 0
.send

mp = .getResponseHeader("location")
dt = .getResponseHeader("Set-Cookie")
.Open "GET", mp
.setRequestHeader "Cookie", dt
.send

mp = .getResponseHeader("location")
.Open "GET", mp
.setRequestHeader "Cookie", dt
.send

mp = .getResponseHeader("location")
dt = dt & "; " & .getResponseHeader("Set-Cookie")
.Open "GET", mp
.setRequestHeader "Cookie", dt
.send

Debug.Print .reponsetext
What am I doing wrong... ? Thanks for any help provided.