Building an Import of XML into Spreadsheet of Wind Generation data.

Hey all,

My company has an XML feed at: http://www.midwestiso.org/misoRIA/se...esponseServlet


I would like to write a Excel Macro that will query this XML once an hour around 5 minutes after the hour and update the values back into the spreadsheet.

Basically once the query runs for an hour, the values should be added to a list of existing hours values. The macro should find the next empty row and add the records there. Like a growing table.

I would love to just have a spreadsheet attached to a response to this post that does this. Please try not to destory the site with hits, but it shoudl be able to take a bunch.

I should mention the data in the XML only changes once an hour, sometime around 30 seconds after the top of the hour. So 5 minutes after the hour should always pull the newest data.

THANK YOU ALL SO MUCH...

can't find the server at www.midwestiso.org

??

34567890

Ohh yea, sorry about that. Our site is only available to IPs originating from the US!