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

by 
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.

More Related Contents:

  1. SumIf using Excel VBA
  2. How can I call a macro which contains a loop but only run one iteration of that loop?
  3. Test or check if sheet exists
  4. How can I find last row that contains data in a specific column?
  5. Is there any event that fires when keys are pressed when editing a cell?
  6. Does the VBA “And” operator evaluate the second argument when the first is false?
  7. Split cell values into multiple rows and keep other data
  8. Save each sheet in a workbook to separate CSV files
  9. Is VBA an OOP language, and does it support polymorphism?
  10. Export each sheet to a separate csv file
  11. What are .NumberFormat Options In Excel VBA?
  12. Excel: How to check if a cell is empty with VBA? [duplicate]
  13. Detect if range is empty
  14. Checking if a worksheet-based checkbox is checked
  15. Faster way to remove ‘extra’ spaces (more than 1) from a large range of cells using VBA for Excel
  16. Uncheck all checkboxes across entire workbook via CommandButton
  17. VBA workbooks.Close without being prompted to if the user wants to save?
  18. Extract Data from Word Document to an Excel SpreadSheet
  19. Excel macro -Split comma separated entries to new rows [duplicate]
  20. VBA equivalent to Excel’s mod function
  21. Excel macro – paste only non empty cells from one sheet to another
  22. Pointers needed for speeding up nested loop macro in VBA
  23. VBA editor auto-deletes spaces at the ends of lines
  24. ‘1004’: “The sort reference is not valid.”
  25. Select entire column in table using Excel VBA
  26. Create hyperlink to another sheet
  27. Reducing WithEvent declarations and subs with VBA and ActiveX
  28. Convert Early Binding VBA to Late Binding VBA : Excel to Outlook Contacts
  29. Function Overloading and UDF in Excel VBA
  30. VBA: Modify chart data range

Leave a Comment