Win http request not working - IE vs Chrome

[scottiex]

I have some old code that pulls data using GET http request

Please Login or Register  to view this content.

now it is failing. this seems to be because IE is no longer supported (IE cant pull the data but chrome can)

how can I get it to work ideally without some complicated piloting of a chrome session. I also don't have selenium set up.

[Marc L]

As on my side IE is still supported so it seems you use a too old ActiveX, use a more recent one like XMLHTTP2 or better WinHttp …

[scottiex]

Thanks Marc,

yes i will update it. although unfortunately that doesn't seem to resolve my issue.

We have also found we can access the location outside our RDS, so the initial suggestion that it was unsupported and that stopped it functioning was probably misleading.

it looks like I have 2 questions now

1) if it does become fully unsupported what is he most straight forward solution should I put in place? what are others planning to do?
I know selenium exists but I'd like a solution that just works on a computer with standard products like chrome/microsoft edge etc without extra drivers etc if possible.

and regarding my immediate issue,

2) I suppose the issue may be outside the scope of excel and vba, but any suggestions for investigating it?

the url just moved (so it is on another server), It has been suggested it could be proxy issues or to do with the Transport Layer Security. We tried changing proxy settings in the code (using the below) but I just get "The operation timed out".

Please Login or Register  to view this content.

[Marc L]

Under VBA I use only some web requesting via WinHttp and when not possible just piloting Internet Explorer.

Some use Power Query in some cases as you can see in samples within Excel forums …

[scottiex]

ok thanks i'll look at power query.

for anyone else's information they resolved the practical issue by something to do with the TLS