The most recent content from our members.
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…
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
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.
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…
Could you please give me an Excel-VBA command to call the Workspace-Excel Menu-command Excel Menu “Workspace” -> Options -> Online -> “Shut Down”
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:…
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…
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".…
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,…
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…
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…
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…
Posting this query on behalf of an external client: The following VBA function stopped worked for me: Function Reuters_IDN(Sec As String, Field As String) Dim res As Variant res = "Retrieving..." While res = "Retrieving..." res = Application.Run("RtGet", "IDN", Sec, Field, "") DoEvents Application.RTD.RefreshData Wend…
Can you tell me how to get LSEGVbaApis.bas module?
It looks like you're new here. Sign in or register to get started.