View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JB JB is offline
external usenet poster
 
Posts: 115
Default 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.