-
With the new commands it seems to hit later, but still, after a few hundred requests (my macro runs
-
Hi Team, posting on behalf of client - Macro Code refreshes a selection
Query : Do we have the same code for macro where it refreshes a selection? As per client, the file has a multiple tab. Upon checking, there are the available macro code that we have : - "WorkspaceRefreshAll" - refreshes all workbooks in the current instance of Excel. - "WorkspaceRefreshWorkbook" - refreshes current…
-
VBA Query
Hello Team, I am raising this query on behalf of a client. 1.Client would like to know more about below WORKSPACE office add-in update on VBA, such as how to use it? Below is the office add-in update log 26.20.9.0 New option to switch between Asynchronous and Synchronous modes in VBA. — How to use it? 2.Please provide an…
-
VBA related question -WorkspaceRefreshSelection
HI Devportal, Good morning. I’ve got a spreadsheet with three DSGRID calls, which are refreshed by vba calling application.run “WorkspaceRefreshSelection”,True. The screenshot below shows an example where the RI values for all the stocks is the sam on the 31/3/2003 as it was on the 28/2/2003. This is not a general issue on…
-
Can someone check and assist our user related to Excel Macro please.
https://us.v-cdn.net/6038239/uploads/4X92DWMG1EVF/eikon-template-2025-281-29.xlsx ISINs were working fine when it was run manually,however, upon using client's Macro it's not working and having some issues.
-
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:…
