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