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