Skip to content

Instantly share code, notes, and snippets.

@rgherta

rgherta/httprequest.xlsm

Last active January 19, 2017 12:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rgherta/bca458df6f429b7235723c0114673593 to your computer and use it in GitHub Desktop.
Save rgherta/bca458df6f429b7235723c0114673593 to your computer and use it in GitHub Desktop.
Download ZIP
HTTP request in VBA
Raw
httprequest.xlsm
'Using Microsoft XML, v6.0
Sub postrequest()
Dim conn As New XMLHTTP60
conn.Open "post", "https://duckduckgo.com/?q=hello", False
conn.send
MsgBox conn.statusText
ActiveSheet.Range("a1").Value = conn.responseText
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment