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:
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?
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 & "®ion=US&lang=en-US", _
"rss").Name = "rss_Map"
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?