Yahoo Finance Headlines RSS Map Error

gStormcrow

New Member
Joined
Oct 27, 2016
Messages
1
I am pulling RSS news headlines for companies from Yahoo Finance.
I have code that runs perfectly on my home pc, but is giving an error on my work pc.

Home computer: Windows 7 and Excel 2007
Work computer: Windows 7 and Excel 2010


Error message when code is run:
Run-time error '-2147217376 (80041020)':
XML Parse Error

The error is with this code:
Code:
ActiveWorkbook.XmlMaps.Add( _
     "[URL="https://feeds.finance.yahoo.com/rss/2.0/headline?s="]https://feeds.finance.yahoo.<wbr>com/rss/2.0/headline?s=[/URL]" & ticker0 & "&region=US&lang=en-US", _
     "rss").Name = "rss_Map"
Note that ticker0 is a string with the company's ticker, and this code runs perfectly on my home computer.


On my work computer I have tried to map the RSS feed without running the code by doing this: pressing the XML Maps button on the XML Source sidebar -> Add -> paste the URL into the File name.
When I do that, I get this error: Cannot load the specified XML or schema source.

Also, I get the same XML load error on my work computer when trying to map some other RSS feeds (other than Yahoo), like this one:
http://rss.nytimes.com/<wbr>services/xml/rss/nyt/US.xml

Anyone have any ideas about what is causing the errors on my work computer?
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Forum statistics

Threads
1,215,061
Messages
6,122,921
Members
449,094
Latest member
teemeren

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top