How to re-write MSXML2.XMLHTTP from MS Excel VBA [closed]

asked 2013-12-01 15:27:35 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

The following works well for MS Excel.

Sub testXMLHTTP_VBA()

Dim strResponse As String

Dim objHttp As Object

Set objHttp = CreateObject("MSXML2.XMLHTTP")

objHttp.Open "Get", "http://www.yoursite.com/", False

objHttp.send

strResponse = objHttp.responseText

Set objHttp = Nothing

[A1] = strResponse

End Sub

edit retag flag offensive reopen merge delete

Closed for the following reason not a real question by Alex Kemp
close date 2015-10-05 01:43:08.919149