J
JB
Worksheet A is saving every 5 seconds. Worksheet B is refreshing links from
A every "x" seconds. When these events occur concurrently, I get a pop-up
asking that I select the source file (A) that was not found during the macro.
If I cancel out, it yields a 1004 error.
Any ideas of how to get around the "error"? (the error occurs in the top of
the code (filename))
ActiveWorkbook.UpdateLink Name:= _
"\\DTCNAS-ILSP002\Mandatory\Analysts - Working Files\Josh\Live Market
Securities.xls" _
, Type:=xlExcelLinks
Range("A1").Select
Call UpdateTime
End Sub
Sub UpdateTime()
Application.OnTime Now + TimeValue("00:00:01"), "UpdateLinks"
'On Error Resume Next
End Sub
Thanks in advance....
A every "x" seconds. When these events occur concurrently, I get a pop-up
asking that I select the source file (A) that was not found during the macro.
If I cancel out, it yields a 1004 error.
Any ideas of how to get around the "error"? (the error occurs in the top of
the code (filename))
ActiveWorkbook.UpdateLink Name:= _
"\\DTCNAS-ILSP002\Mandatory\Analysts - Working Files\Josh\Live Market
Securities.xls" _
, Type:=xlExcelLinks
Range("A1").Select
Call UpdateTime
End Sub
Sub UpdateTime()
Application.OnTime Now + TimeValue("00:00:01"), "UpdateLinks"
'On Error Resume Next
End Sub
Thanks in advance....