-
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
-
Refreshing a Specific Worksheet on Workspace VBA
Having difficulty with using the Application.Run "WorkspaceRefreshWorksheet" VBA function on Workspace. I found the information below on refreshing worksheets: 2 - EikonRefreshWorksheet takes a third optional parameter worksheetToRefresh. This is the name of the worksheet to refresh. It can be in "[Book1]Sheet1" format to…
-
PLVApi.Dll
Hi, I'm trying to run VBA code written by someone else, in Excel. I have the Workspace Add In running, and logged in. When I run the VBA code, I get this error message: This dll indeed does not exist in the path indicated in the error window. I thought it might be elsewhere, but I cannot find it in my PC. I looked in the…
-
Replacement for Rhistory and Dex2 for migration from Eikon to Workspace
Hi, I am currently using RhistoryAPI.dll and Dex2.dll in my VBA code with Refinitiv Eikon. Apparently these APIs are under COM APIs for use in Microsoft Office and aren't supported in Refinitiv Workspace. What are the replacements that I can use?
-
Could we log in Refinitiv Workspace Addin using the VBA code like before? (Before: Eikon COM Addin)
Now, we can still use the VBA code [Application.Run "PLLoginEventHandler"] to log in Eikon COM Addin. However, we will be using a new version of Eikon, the Refinitiv Workspace, so common VBA code may no longer work. I would like to ask if there is a way to log in Refinitiv Workspace Addin using VBA code like before?…
