0

Excel Mac do not support CreateObject method so cannot use MSXML2.ServerXMLHTTP and similar objects.

Simple HTTP post example using Querytable I got from this answer How can I send an HTTP POST request to a server from Excel using VBA?

For OAuth authentication, I think HTTP headers has to be posted to server, Can this be done using QueryTable ? is there any other way to do OAuth authentication in MAC Excel ?

Thank you.

Shafeek
  • 135
  • 1
  • 7
  • I guess the only way is make XHR with credentials for authorization, then make another XHR to retrieve the necessary data, and parse the response. Please share the URL and data you need to retrieve. – omegastripes Nov 06 '17 at 09:38
  • Thanks for comment. will that work in mac excel ? – Shafeek Nov 06 '17 at 15:20
  • Actually I'm not quite familiar with Mac, seems some workaround is necessary to make XHR in Mac, check the [link](https://stackoverflow.com/q/15981960/2165759). – omegastripes Nov 06 '17 at 18:33

0 Answers0