Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Runtime 1004 | Excel Programming | |||
runtime 1004 error | Excel Programming | |||
runtime 1004 error | Excel Programming | |||
Runtime error 1004 | Excel Programming | |||
runtime error 1004 | Excel Programming |