ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Saving/Refreshing with Ontime (https://www.excelbanter.com/excel-programming/401945-saving-refreshing-ontime.html)

JB

Saving/Refreshing with Ontime
 
Workbook A is a source document with live updates to a mainframe system and
is saved every 5 seconds to capture updates.

Workbook B is linked to Workbook A and links are refreshed every 10 seconds.
Eventually, code in B to "refresh" data from A occurs while A is saving.

I just need it to skip the error and resume the ontime function. Any ideas
or suggestions would be greatly appreciated.

NOTE: The timing of each action below is random and can be changed to
different intervals.


All times are GMT +1. The time now is 04:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com