VBA refresh issue for =RDP.Price()

Denis Gribenyuk

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 times) . And we try to add a wait function after to allow more time of calculation but it doesn’t help.

The Reuters formula we try to refresh is =RDP.Price()

The VBA we are using is :

“ Sub RefreshReuters() Application.Run "WorkspaceRefreshWorksheet", True, 12000 Application.Wait (Now + TimeValue("00:00:03")) End Sub “

Thanks, Denis

Jirapongse

@Denis Gribenyuk

Thank you for reaching out to us.

For questions regarding the Workspace Excel, please contact the Workspace support team directly.

Regarding the sample code for WorkspaceRefreshWorksheet, please refer to the following discussions.

• Question on Excel Macros
• RDP Addin function in Excel and handling these functions by using Macro(VBA)