Sending data from excel to Server using HTTP Post

Question

How can I send data to Server from excel using HTTP Post?

Lets say the URL is: http://testingHttpPost/

And I want to send data from Cells A2 and B2. How would I get this done in VBA?

Thanks in advance

Community · Accepted Answer · 2017-05-23 11:48:03Z

6

Sub XMLPost()
Dim xmlhttp, sData As String

    With ActiveSheet
        sData = "x=" & URLencode(.Range("A2").Value) & _
                "&y=" & URLencode(.Range("B2").Value)
    End With

    Set xmlhttp = CreateObject("microsoft.xmlhttp")

    With xmlhttp
        .Open "POST", " http://testingHttpPost/", False
        .setrequestheader "Content-Type", "application/x-www-form-urlencoded"
        .send sData
        Debug.Print .responsetext
    End With
End Sub

For URLencode function see here: How can I URL encode a string in Excel VBA?

edited May 23, 2017 at 11:48

CommunityBot

11 silver badge

answered Jun 11, 2011 at 0:00

Tim Williams

169k8 gold badges104 silver badges143 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user793468 Over a year ago

Thanks! Tim In your above example, If I want to insert the data in a SQL Server DB. Using your above example of HTTP Post how could I insert the "x" and "y" data in Table "DataTable" in columns "X" and "Y" respectively?

Tim Williams Over a year ago

Sorry - I'm not that familiar with asp.net(mvc). Typically the values X and Y will show up in the request.form name-value collection. Once you have those you can use ADO to do the insert. That's about as much as I can offer. I suggest you post a more specific question on that, including what language you're using for your asp.net

Collectives™ on Stack Overflow

Sending data from excel to Server using HTTP Post

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related