The most recent content from our members.
How to do do "Refresh All Workbooks" and "Pause Update" in Refinitiv Workspace Excel with VBA?
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?
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…
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
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…
...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
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…
Macro1.PNG Hi Team, one of our client is facing issue with Macro not working when try to save PDF
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…
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…
It looks like you're new here. Sign in or register to get started.
