I have an excel sheet that pulls news headlines from Eikon and scrolls the news headlines from the top of the Excel page to bottom as news stores come in. It just stopped working about 2 weeks ago. It looks like the Excel sheet uses a macro to pull in the new stories. I don't know who built it. I don't see any errors. Refinitiv Eikon is online and pulling data. I reached out to Eikon customer support and they told me to come here and ask for help. Thanks
I think that most likely the spreadsheet used to retrieve news headlines using the RIC N2_UBMS, which has been retired. The VBA code in the spreadsheet needs to be updated to use the RIC NFCP_UBMS. Some field names and perhaps the filtering logic may also need to be updated. If you post the spreadsheet on this thread (put it in a zip file and attach it to your post), I can take a look and update it. But given that no one owns this spreadsheet, you may want to consider alternative solutions, as software not owned by anyone may stop working at any time, and you may not be able to fix it.
I updated the spreadsheet. For now it is able to retrieve and display news headlines. If you need to change the filter expression, I'm afraid it won't be as easy as previously. You would need to add any news codes you'd like to use in the filter expression to the table in the News Codes worksheets that maps user friendly codes like "COM" to cryptic codes like "A:4" published with updates to NFCP_UBMS RIC. Since it looks like the purpose of this spreadsheet is to project news headlines to a wallboard, I'm guessing you don't need to change the filter expression frequently, so this shouldn't be a very big issue.
Let me know how it works for you.