HTTP request - simple problem

I have a small server application (PHP) that is envoked with a URL and writes the attached parameters to a file. I want a client application to do the HTTP work. How do I call an URL from VBA without launcing a browser

The URL (requested by a client application, not a browser) looks like http://www.test.com/fileWrite.php var1=234&var2=26&var3=4



Answer this question

HTTP request - simple problem

  • Whoisit

    Hi Derek,

    Thanks, that did it!

    Kristjan


  • KarimRadi

    Hi,

    You can use MSXML's XMLHTTP object to make requests. Here's an example:

    Private Sub Command1_Click()
     Dim HttpReq As New MSXML2.XMLHTTP40
     
     HttpReq.open "GET", "http://XMLSampleServer/CatalogServer.asp", False
     HttpReq.send
     MsgBox HttpReq.responseText
    End Sub


  • HTTP request - simple problem