-
Workspace Add-on | Excel File Freezing
User has an issue with one particular excel file and it's stuck at loading, mouse is also a blue loading circle so they cannot engage with the file, only close via Task Manager. It's a big file with macros, so I've been told it might be VBA related. Troubleshooting steps completed: Cache cleared Temporary files cleared…
-
Historical Pricing with more than one underlying in excel vba
Hi, We used excel vba code with the old "RHistoryAPI.dll" to query the prices for several stock underlyings. In the new "LSEG COM Library for Workspace" I also looked at the example file for historical pricing from the website "https://developers.lseg.com/en/api-catalog/workspace-sdk/lseg-com-library-for-workspace".…
-
Stock Div Data using LSEG COM library for Workspace in Excel VBA
Using the LSEG COM library for Workspace in Excel VBA what is the best way to return company dividend information? TR.DivExDate etc.
-
I try to convert the Excel formula to VBA function
I try to convert the Excel formula =RDP.Data("BCYSYU.S", "ASK", "RTFEED:IDN_SELECTFEED") into a VBA function Application.Run("RDP.Data", "BCYSYU.S", "ASK", "RTFEED:IDN_SELECTFEED"). Unfortunately, it doesn't work. Can you pls assist? But before (Refinitiv Eikon) it was possible to run RtGet via Application.Run So, this…
-
Why does Alt+F11 won't open WS VBA Editor?
With the latest version of WS, Alt + F11 is not opening the VBA editor. Please liaise directly with the client to fix the issue and / or with product team to raise an enhancement request. Also, can you give me the regression tests performed before releasing a new WS version? Client's verbatim: Under WIN11, with Office 2021…
-
workspace/Excel/VBA - Application.Run "PLPauseResumeEventHandler"
Hi LSEG, Please confirm if there are any updates for Workspace including Application.Run "PLPauseResumeEventHandler"? The last post in October 2024 stated no. Regards Adam
-
Live Mode via VBA
Hello, how can I activate in Workspace Excel "Contribute Now » Live Mode" via VBA ? We're currently experiencing a problem with some users where the Excel workspace jumps to "Manual Mode" when opening it. To avoid this, I'd like to enable "Live Mode" when opening the sheet using VBA.
-
How can I get the BloombergUI.xla Excel Add-in back?
Following the recent Workspace upgrade, one of our workbooks no longer pulls in price data. Looking at the VBA Project References I can see that BloombergUI.xla no longer exists (C:\blp\API\Office Tools\BloombergUI.xla). This has been discussed under FMC Request 28-062025226 and we were advised to reach out here for help…
-
Excel-VBA Command posting on behalf of a client
Could you please give me an Excel-VBA command to call the Workspace-Excel Menu-command Excel Menu “Workspace” -> Options -> Online -> “Shut Down”
-
AdfinXAnalytics in Workspace
Hi Team, Is there any way to use AdfinXAnalytics with Workspace Excel? We have a user who has this in his Excel file. I found some references to an LSEG COM API solution, but it doesn't seem to include AdfinXAnalytics, just DEX and Real Time:…
-
Workspace VBA Add-in
Client has downloaded the COM addin for Workspace to enable VBA but wants to know why he his file is not updating. Please see the images attached. Can send the file in question if needed. And client query below: "Can you please have someone who is an expect on the VBA side to confirm why these Public Functions are not…
-
Could you provide me with a documentation for library (oRtList As WorkspaceRtLib.AdxRtList)?
Raised this on client's behalf. Looking forward to your response. Contact Name : Majdeddine Younes Account Name : Landesbank Baden Wuerttemberg Query : I used to use AdfinXRtLib (Eikon) in my VBA and would like to have a similar library while using Workspace. Since I now have the Adfin Analytics tab in my workspace Excel,…
-
Migrating VBA Code from EIKON AdxRtList Library to Refinitiv Workspace
I am working on converting an Excel-based calculation tool that currently uses the EIKON AdxRtList Library to stream real-time underlying data. The goal is to adapt the VBA code so it works with Refinitiv Workspace instead of EIKON. Details: The VBA tool has the following components: A class module that interacts directly…
-
EXCEL | VBA
we are moving to LSEG Workspace. I need to open a Workspace Excel with VBA. The workspace add- in is inserted correctly via File --> Options and if you manually open an Excel, the workspace add-in is also included. But if I call an Excel via VBA, unfortunately the workspace add-in is missing. What must the VBA code be to…
-
User upgrading to from Eikon to Workspace with a spreadsheet using VBA created by Reuters
Hello, I wanted to ask if a user who had a spreadsheet created by our previous colleagues can submit his file to be upgraded by someone in the devportal? He submitted the file to the FMC Team but they don't support VBA and asked him to try here. I can act as a point of contact or I can ask him to submit his request here if…
