htmlexcelvbahttpwebrequestexcel-web-query

getHTTP with (Excel) VBA?

I'm searching for a query for an Excel VBA macro to get a web page's HTML source code as a string.

I've found some source with getHTTPrequest but I can't register .net framework system.dll or link it.

Thanks!

Solution

  • Close enough: How can I send an HTTP POST request to a server from Excel using VBA? — It's even for Excel ;-)

    Just use a GET request instead:

    objHTTP.Open "GET", URL, False

    MSDN: Using the WinHttpRequest COM Object - Retrieving Data Using Visual Basic