Sending HTTP Get Commands

[PaulHilgeman]

Each day when the new data is imported, I am now being asked to send
HTTP strings to an external website/database. I can send in fairly
simple XML format, with some of the parameters from my database.

How would I automatically do this? It would be simple enough to run a
query for all jobs added to the database today. Then I need to parse
out certain things like PO Number, Phone Number, Order Number etc, and
generate a string like this:

http://www.website.com/scripts/prog...allOrderNumber=62589&PhoneNumber=xxx-xxx-xxxx

The data like StoreNumber, InstallPO, InstallOrderNumber, Phone Number
all come from the data that is already in an access table.

So, once I get a query made, with all of the pertinent data, how do I
go about sending all of the HTTP GET commands.

Thanks!!!

 

[Steve Schapel]

Paul,

This is beyond the scope of macros. You will need to use VBA for this.

Set a Reference to 'Microsoft XML v5.0'. This will then give you access
to the XMLHTTP object.

Your code will then include something like this (skeleton air code!):

Dim MyxmlHTTP As xmlHTTP
Set MyxmlHTTP = New xmlHTTP
MyxmlHTTP.Open "GET", "http://…<your url>" , False
MyxmlHTTP.send