J
JB
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.
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.