Hello,

I have a tough question for the community. I am trying to figure out how to get xml from a web based API into Excel via VBA. So far I have read the best way is probably to first somehow create the xml document, save it locally then import it into Excel. I am good with this (if this indeed the best way to do it) but I know almost nothing about XML and APIs. Here is the API query(?) to get the XML. My question is- what do I do with it in Excel? Any help would be much appreciated.

With this query(?) example, you can see there is a url that is constructed with the XML parts under the <HotelListRequest> tag. How do I get from this code to a saved/local XML document?

http://api.ean.com/ean-services/rs/hotel/v3/list?
minorRev=[current minorRev #]
&cid=55505
&apiKey=[xxx-yourOwnKey-xxx]
&customerUserAgent=[xxx]
&customerIpAddress=[xxx]
&locale=en_US
&currencyCode=USD
&xml=
<HotelListRequest>
<city>Seattle</city>
<stateProvinceCode>WA</stateProvinceCode>
<countryCode>US</countryCode>
<arrivalDate>08/01/2012</arrivalDate>
<departureDate>08/03/2012</departureDate>
<RoomGroup>
<Room>
<numberOfAdults>2</numberOfAdults>
</Room>
</RoomGroup>
<numberOfResults>1</numberOfResults>
<supplierCacheTolerance>MED_ENHANCED</supplierCacheTolerance>
</HotelListRequest>


Thanks,

learning_vba