Help! Import XML data into Excel hourly

Hello,

I need help with what should be a simple task, but I can't seem to figure it out. I need to take XML data from a thermostat device and paste it into an Excel spreadsheet. I can do this manually without issue, but I want this to be automated and done hourly.

Here is what I want it to look like:

First Column, first row: Insert current date and time
Second Column, first row: import current XML data here

Then, one hour later, I want it to drop to the next available row and repeat. When I have attempted to do this via Macros in Excel, it give me an error on the second attempt about overwriting the XML data. I don't need fancy charts or stylish formatting, just simple data scraping.

Thanks in advance!

Jon

Here is an example of how I can do this once...

https://youtu.be/KCvcHhEB9-8

Here is the error I receive

Capture.PNG

I don't have access to the exact source, since I am not at the site of the equipment. I was just using a local test .xml file, but I can use a web hosted sample file instead to make it simpler.

http://www.w3schools.com/xml/note.xml

Please Login or Register  to view this content.

I still get the same error. Is the Range(Range part correct?

I figured it out. There was an extra Range() in there:

Please Login or Register  to view this content.

Thank you very much for your help. I just now need this to be automated hourly. I believe I can do this with Task Scheduler. If you have any insights into that portion, feel free to offer suggestions.