Hi All

Is there a way of editing an xml source data url or ideally replacing it with a named range variable?
I currently am pulling rss info from Yahoo into excel and creating an xml map via the Developer tab. This part of the process is easier enough (see below youtube link)

http://www.youtube.com/watch?v=AjHv2LkqyPM

However, once the source url link is pasted in, I cannot see how to edit it. As I want to load in headlines from Yahoo relating to stocks I have included these into the url

Eg - http://finance.yahoo.com/rss/headlin...F.PA,AKZA,AMZN etc


Unfortunately, stock codes can change or drop out of use and when this happens, the rss link no longer updates from that point.

One solution might be to be able to edit the url in the xml map, but how as there seems to be no obvious way to do this, or ideally, to have the source url in the xml map linked to a variable such as a named range.

Any thoughts?