Extract xml elements from mutiple urls into Excel

Hi there,

I have searched constantly for 3 days with no luck. I will appreciate any help.

I want to be able to post about 50 urls into column A. All of these links open up to an xml sitemap from where I want to be able to extract the contents of 3 xml elements into columns B, C & D.

I'm including an example of what the sitemap looks like upon opening of the url.

One last important requirement is that I must be able to change the user-agent before the http send request. For example:

http.setRequestHeader "User-Agent", "Mozilla/5.0 (Windows NT 5.1; rv:18.0) Gecko/20100101 Firefox/18.0"

I am aware of how to utilize html tables to extract data.......but unfortunately not versed in how to extract xml data.

Thanks in advance.

Anyone? Please?

Hi,

any URL sample ? Any crystal clear explanation ? Any workbook sample of desired result ?