PDA

View Full Version : Web service through VBA



jibs
08-05-2015, 07:51 AM
I'm trying to accomplish the same as what is done on this site:
http//libkod.info/officexml-CHP-9-SECT-5.shtml#officexml-CHP-9-FIG-16

The only difference is I have more than one parameter to pass in the URL.

So where

query = "http//webservicex.net/uszip.asmx/GetInfoByZIP?USZip=" + zip

is being passed to send I need to do something liek this but can't figure out the syntax


query = "http//webservicex.net/uszip.asmx/GetInfoByZIP?USZip=" + zip & USCity=" + city & USState=" + state

How would I go about doing this?