-
Excel VBA
Client like to use the command code "RtGet("IDN","LCOc1","LAST") in Excel VBA. Is that possible please?
-
Formula error
can you please check if you can assist? “Basically, I have a formula RDP.Search("COMPANY", $B$8, "NBROWS:500 SORT:DTSubjectName:A", , ) which returns a sample 5073619959 5073620114 5073620117 5073619966 5074009689 5051175432 5084167849After I copy it and paste it back as values, I get 5073619959. all values after the first…
-
Excel Spreadsheet crashing (Workspace Data Retrieval, Macros)
Hello Team, Our excel spreadsheet crashes upon retrieving data from Workspace add-in. It can be replicated inhouse. We checked with excel experts (GBC team) and they informed that it has macros and so needs to be raised to Developers to check further. Could you please advise? The file has .xlsm extension, so its not even…
-
Behavior of VBA in the workspace
When the following VBA macro is executed line by line in debug mode, it successfully retrieves the result date of the Reuters function in Eikon Excel and complete without issues. However, in Workspace Excel, the cell remains at "Retrieving..." and a type mismatch error occurs. Is this behavior specific to the validation…
-
Facing issue on SFIL global
Hi Team, Query : SFIL global issue The first issue is they would like to know if there is a VB code for Workspace refresh function as they have a file that gets their data for BID and ASK which uses workspace formula and they also have MID which is the average of BID and ASK but doesn't use workspace formula. When they…
-
How do I write VBA code to call Refinitive Excel function and refresh the underlying data
-
[Workspace] Error PLVbaApis.dll is not found
I am facing an error PLVbaApis.dll is not found. May I know where this can be found? I am trying to connect to WS when starting a file. I can run full macros on that WS, and it works. The only thing that does not work is that 2 line of code
-
VBA refresh issue for =RDP.Price()
Hi Team, Please can you help with VBA query from client below. I wonder if you can provide some instructions on how to use VBA to refresh Reuters formulas in excel efficiently? We are quite struggling with the current VBA as the Excel process hang in the middle and crash after I refresh for consecutive times (usually >3…
-
Question on Excel Macros
Hello the Live Chat couldn't answer my question and referred me to this Forum. It regards to Excel which, to my amazement, is not included in the "Select a category" menu above. I have a macro that calls 10 RICs, one after the other in a loop, downloads the same basic data for each RIC, copy paste the results in another…
-
DoEvents Application.Run "WorkspaceRefreshWorksheet", True, 1200, ActShtName DoEvents what do True
DoEvents Application.Run "WorkspaceRefreshWorksheet", True, 1200, ActShtName DoEvents what do True If we set that false, what will happen in what case?
-
Python- workspace excel implementation
Hi Team, Can you please answer two questions below? 1) Will new workflow (Python-Excel) implementation require additional payable data access licensing (for instance to data API licenses). If yes – then where can we find pricing? 2) Is there a way (please share some sample python file or reference) to initiate some…
-
RDP Addin function in Excel and handling these functions by using Macro(VBA)
For the RDP function to ADDI to Excel, can I use the same Excel macro (VBA) to run a stop update and its recalculte? (as for eikon or workspace addin, I understand that we cannot do such a handle)
-
How to do do "Refresh All Workbooks" and "Pause Update" in Refinitiv Workspace Excel with VBA?
How to do do "Refresh All Workbooks" and "Pause Update" in Refinitiv Workspace Excel with VBA?
-
Workspace Excel-Addin: Pause/Resume Updates
How can I pause/resume the updates in Excel VBA for the Workspace Add-in? I know that for Eikon the function was "PLPauseResumeEventHandler". What is the equivalent for Workspace?
-
Running RDP.Price in VBA
Hi, we have recently migrated the user to Workspace, and later he found some VBA issues. He wanted to find out if there’s any way to run RDP.Price via VBA and assign the result to a variable? Previously he could write a function that waited until the output of the function was no longer “Retrieving” i.e. like so: Function…
