PDA

View Full Version : Extract xml elements from mutiple urls into Excel



superdesi
06-16-2015, 10:02 AM
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.

superdesi
06-16-2015, 07:13 PM
Please.....this can't be hard for the pros out there. Help!