How can I send an HTTP POST request to a server from Excel using VBA?

excel vba http post serverxmlhttp
Matthew Murdoch picture Matthew Murdoch · Oct 1, 2008 · Viewed 268.5k times · Source

What VBA code is required to perform an HTTP POST from an Excel spreadsheet?

Answer

Bill the Lizard picture Bill the Lizard · Oct 1, 2008 
Set objHTTP = CreateObject("MSXML2.ServerXMLHTTP")
URL = "http://www.somedomain.com"
objHTTP.Open "POST", URL, False
objHTTP.setRequestHeader "User-Agent", "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)"
objHTTP.send("")

Alternatively, for greater control over the HTTP request you can use WinHttp.WinHttpRequest.5.1 in place of MSXML2.ServerXMLHTTP.

Related questions

Perform HTTP Post from within Excel and Parse Results

I have access to an API. The API takes an XML post as input and then returns an XML response with the relevant data. I want to Send the HTTP Post to the Server (Authentication and Request will be sent …

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More
How do I declare a global variable in VBA?

I wrote the following code: Function find_results_idle() Public iRaw As Integer Public iColumn As Integer iRaw = 1 iColumn = 1 And I get the error message: "invalid attribute in Sub or Function" Do you know what I did wrong? I tried …

Read More