This is the MSXML tag.

VBA icon

Checking header responses

Sometimes you may need to check the header response when doing a web query. MSXML lets us do this fairly quickly.

Normally we use GET or POST requests to grab responses from a website. But there is another option (are there more?): HEAD requests. These requests return just the headers from whatever URL you call. This way, we can check if the request is well formed or if the website is available prior to making an actual request.

Continue Reading »

learn excel dashboards