-
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…
-
EikonRefresh in VBA (LSEG Workspace)
We will shortly migrate from Refinitiv Eikon to LSEG Workspace and I would like to understand whether the EikonRefresh functions in VBA will continue to work or whether a different approach will be needed. Thanks, Michail
-
From VBA to Python
Years ago I programmed some macros in Eikon that capture and save in a folder on his PC hard disk the graphs of about 200 RICs (stocks, indices, currencies, etc.). They are graphs that have studies, annotations, trend lines, Fibonacci, and that are generated in daily and weekly format. The macros convert all the graphics…
-
Hi how can i refresh all TR formulas in a workbook for the new workspace add in, in vba? I used t...
...o do: Application.Run "EikonRefreshWorksheet", True, 10000 when eikon was still in place Hi how can i refresh all TR formulas in a workbook for the new workspace add in, in vba? I used to do: Application.Run "EikonRefreshWorksheet", True, 10000 when eikon was still in place
-
Issue with "WorkspaceRefreshWorksheet" on Workspace VBA
I'm having difficulty with including the workbook name on "WorkspaceRefreshWorksheet". I'm using: Sub WSRefreshSheet() DoEvents Application.Run "WorkspaceRefreshWorksheet", True, 120000, "[Book1]Sheet1" DoEvents End Sub But it doesn't run unless I remove the Workbook name ([Book1]). Works perfectly fine if only "Sheet1" is…
-
Hi Team, one of our client is facing issue with Macro not working when try to save PDF
Macro1.PNG Hi Team, one of our client is facing issue with Macro not working when try to save PDF