Hi All,
I know how to build an RSS feed into Excel for a given website. I'm trying to find out if there is a way to change the RSS feed depending on a drop down selection. So lets say I was looking at financial news headlines in Excel and wanted a drop down with CNBC, Bloomberg and Yahoo Finance. When selecting one of the options, it would pull up the RSS feed for that respective site.
My issue is that I cannot find anything remotely close online that shows how to do it and have struggled overcoming the fact that the RSS feed is linked to particular cells.
If anybody has a solution for my dilemma, I would greatly appreciate any feedback.
If this is a limitation of Excel, I will understand.
I know how to build an RSS feed into Excel for a given website. I'm trying to find out if there is a way to change the RSS feed depending on a drop down selection. So lets say I was looking at financial news headlines in Excel and wanted a drop down with CNBC, Bloomberg and Yahoo Finance. When selecting one of the options, it would pull up the RSS feed for that respective site.
My issue is that I cannot find anything remotely close online that shows how to do it and have struggled overcoming the fact that the RSS feed is linked to particular cells.
If anybody has a solution for my dilemma, I would greatly appreciate any feedback.
If this is a limitation of Excel, I will understand.