Excel MAC and WinHttpRequest or Msxml2.ServerXMLHTTP

[jcorlando]

Hi All,

My client is using Excel on a MAC
and I need to send an HTTP GET command via VBA.

The code fails using: Msxml2.ServerXMLHTTP

Then error messages says missing references:
- Microsoft HTML Object Library
- Microsoft Internet Controls
- Microsoft WinHTTP Services, version 5.1.

Questions:
1) How can I add these missing libraries?
I can't seem to find them like I can in a Windows.
2) Any thoughts on a cross platform system?


Thanks,

John,
In Annapolis, MD

 

[jcorlando]

-- Bump --

Anyone familiar with VBA in Excel MAC

 

[KARL7]

-- Bump --

Anyone familiar with VBA in Excel MAC

A potential alternative to avoid having to select the library is to use an object i.e.

​

<code style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; ">Sub http()Dim MyRequest As Object

Set MyRequest = CreateObject("WinHttp.WinHttpRequest.5.1")

MyRequest.Open "GET", _ "http://www.google.com"


' Send Request.
MyRequest.Send

'And we get this response
MsgBox MyRequest.ResponseText

End Sub


This worked for me,Sending http requests with VBA from Word - Stack Overflow</code>

 

[jrwagz]

This method of creating the object via:

Set MyRequest = CreateObject("WinHttp.WinHttpRequest.5.1")

Does not work on Excel for Mac 2011 (the original question).

The best method I have found, and plan to test, is to issue "curl" requests via ShellExec How do I issue an HTTP GET from Excel VBA for Mac 2011 - Stack Overflow