Multiple XML feeds via VBA/Macro?

[cks_cropper]

Hi all,

I have come to a point where I am unsure how to accomplish something based on my current knowledge.

What I am looking to do is have 3 columns in a spreadsheet - Date (A1), XML Feed URL (B1), Value (C1).

The XML feed URL will be generated based on the date in the first column by appending a parameter of "date=A1" (for example) using the concatenate function - simple enough so far.

Where I am stuck now though is how get the data from the XML feed URL in column (B1) and place a specific part of the XML feed data into the Value column (C1).

There is likely to be 30 different XML feeds which will always be from today + 30 days from now.

The idea being so we can see the required information for the coming month.

Has anyone had any experience of doing this before?

Thanks
CKS

 

[Sektor]

Place example of what you have and what you want.