Perform hidden http-request from vba

Question

I want to perform a hidden HTTP-GET request from MS-access, as simple as possible, without any extra libraries/components.

Just a simple declare all needed.

Has WinHttp left the building??

did you have a look at this thread: stackoverflow.com/questions/158633/…? — JMax
– JMax, Commented Aug 31, 2011 at 9:13

Patrick Honorez · Accepted Answer · 2011-08-31 09:28:11Z

6

Here is a great page about that.

answered Aug 31, 2011 at 9:28

Patrick Honorez

25.4k12 gold badges97 silver badges163 bronze badges

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

Comments

Teson · Accepted Answer · 2016-08-08 08:23:13Z

3

Hope this helps

 Dim xhr As Object
 Dim webServiceURL As String
 Dim actionType As String
 Dim thisRequest As String
 Dim targetWord As String

 WebServiceURL = "http://services.aonaware.com/DictService/DictService.asmx/"
 actionType = "Define?word="
 targetWord = "Marketplace"
 thisRequest = webServiceURL & actionType & targetWord

 'use late binding
 Set xhr = CreateObject("Microsoft.XMLHTTP")  

 xhr.Open "GET", thisRequest, False
 xhr.Send

 If xhr.status = 200 Then
   Debug.Print xhr.responseText
   MsgBox xhr.getAllResponseHeaders
 Else
   MsgBox xhr.status & ": " & xhr.statusText
 End If

 Set xhr = Nothing

edited Aug 8, 2016 at 8:23

Teson

6,7469 gold badges50 silver badges70 bronze badges

answered Aug 5, 2016 at 6:54

Adarsh Madrecha

8,20514 gold badges78 silver badges129 bronze badges

Collectives™ on Stack Overflow

Perform hidden http-request from vba

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related