Can someone point me in the right direction to how I can pull data from a website using vba code? I can generate the XML data, (attached) but do not know how to extract it. I've never extracted data from a website so I have no idea where to begin (but I do have moderate knowledge in vba).
The XML data is weather information and I'm mainly interested in the <dailysummary> section, <maxtempi> and <mintempi>
The XML is generated through an API call to Weather Underground:
<key> is a personal key assigned by Wunderground