![]() |
if Error, Pause or Loop
Is there a way to, If Error then loop back and try again.
This is a live file which is connected to my file and I have it save every 13 seconds but if the live link is saving, it errors out. '///////////////////////////////////////////////// Sub UpdateLinks() ActiveWorkbook.UpdateLink Name:= _ "\\DTCNAS-ILSP002\Tesing\LiveLink.xls" _ , Type:=xlExcelLinks Range("A1").Select Call UpdateTime End Sub Sub UpdateTime() Application.OnTime Now + TimeValue("00:00:13"), "UpdateLinks" End Sub -- ca1358 |
All times are GMT +1. The time now is 09:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com