VBA related question -WorkspaceRefreshSelection

RALPHPAOLO.NAVARRO

HI Devportal, Good morning.

I’ve got a spreadsheet with three DSGRID calls, which are refreshed by vba calling application.run “WorkspaceRefreshSelection”,True.

The screenshot below shows an example where the RI values for all the stocks is the sam on the 31/3/2003 as it was on the 28/2/2003. This is not a general issue on the spreadsheet, it happens occasionally, and at other times the RI for a stock in the later date is not related to the stock’s RI value in the earlier month, for example one stock has approx. 2000% growth on one call, but when I refreshed the data it had a return less than 10%.

 =@DSGRID ($A$20:$A$230,$N$15:$O$15,$N$14,"","","ColHeader=true;DispSeriesDescription=true;DispDatatypeDescription=true")

Is my VBA routine the best way to get the data refreshed, or should I be refreshing the data differently.

Thank you

Jirapongse

@RALPHPAOLO.NAVARRO

Thank you for reaching out to us.

To use this function, please refer to this discussion.

However, there are other functions, such as WorkspaceRefreshWorkbook, and WorkspaceRefreshWorksheet.

To confirm how this function works or to report any issues with its functionality, please contact the helpdesk support team directly via LSEG Support.