Using Excel 2011 - get "ActiveX can't create object" error 429

Question

I have read several posts about this error, but haven't found one that actually offers an alternative to this coding for Mac.

In my case, I am trying to connect to a remote host to download a file, and this is the code snippet that fails (first line):

Set objHTTP = CreateObject("Msxml2.ServerXMLHTTP")

strPost = "https://[website]/HTTP/Authenticate.aspx"

objHTTP.Open "POST", strPost, False

Call objHTTP.setRequestHeader("Content-Type", "application/x-www-form-urlencoded")

objHTTP.send ("Username=user&Password=pwd")

replyTXT = objHTTP.responseText

I have no control over the remote host, so I am hoping that someone can offer an alternate method of coding this?

Any help will be greatly appreciated.

Cheers,

Allan

Answer 1

You get that error because Mac excel does not support Active-X objects. How to recode this (if it is even possible) depends on the remote server, and what you are trying to do.

You haven't found any alternatives because there may not be any.