Application.Run ("PLPauseResumeEventHandler") or other vba codes?
fixing some vba codes
wanted to pause workbooks auto update for eikon via excel using vba
was using Application.Run (PLPauseResumeEventHandler)
anyway to split it into pause and resume only? or any other methods to control it?
Application.Run (PLPauseResumeEventHandler) only toogles on and off, any other ie
Application.Run (PLPauseEventHandler) to only pause it and
Application.Run (PLResumeEventHandler) to only resume the eventhandler
basically want to halt all refinitiv-excel updates/data retrieval when opening the spreadsheets
1. Application.Run (PLPauseResumeEventHandler) to split it into pause and resume
2. Any other method other than method above
3. Application.Run ("TRExcelReCalculateUpdatedFctManualMode") for this, is there a way to change it to refresh workbook or sheets only
4. is there any differences between method above and 'DoEvents
'Application.Run "EikonRefreshWorkbook", True, 120000
'DoEvents
