Got a solution on Excel for web scraping which is working fine on Windows.
Dim xmlRequest As New MSXML2.XMLHTTP60
Dim htmlDoc As New MSHTML.HTMLDocument
...
xmlRequest.Open "GET", queryURL, False
xmlRequest.send
htmlDoc.body.innerHTML = xmlRequest.responseText
I tried to run in on Mac but it is not working as the referenced libs MSXML and MSHTML are missing.
So far, I couldn't find them to download for Mac. Seems that they do not exist...
Is there another way to achieve the same result ? I already tried with QueryTables and executing a macro but it is horribly slow, I wouldn't call it a solution.