Error Continue in Excel VBA
Posted on 2007-11-20
This is Excel 2003.
I have this ÃƒÂ¢Ã‚Â€Ã‚ÂœFileÃƒÂ¢Ã‚Â€Ã‚Â that I have linked to and I need to save every 13 seconds to keep it live.
But sometimes the original file is saving and my procedure errors out. How do you tell it to ÃƒÂ¢Ã‚Â€Ã‚Âœ If error then continueÃƒÂ¢Ã‚Â€Ã‚Â without popping up the error, so I donÃƒÂ¢Ã‚Â€Ã‚Â™t have to manually do it.
Any help would greatly be appreciated.
ActiveWorkbook.UpdateLink Name:= _
Application.OnTime Now + TimeValue("00:00:13"), "UpdateLinks"