Run time error with auto update VBA code

**galvinpaddy** · 01-18-2013, 03:28 AM

Good morning happy campers,

I have the following codes:
Module 1

Please Login or Register  to view this content.

This Workbook -

Please Login or Register  to view this content.

For the most part, all the codes work fine, in short they refresh the values on the sheet every 5 seconds, triggered by opening the workbook AND when a change is made to the workbook.
However, at times i get a run time error - 'Method "UpdateLink' of Object '_Workbook' failed
highlighting the following in yellow (from Module1)

Please Login or Register  to view this content.

Could anyone please shed some light for me please?
Kind regards.

**OllieB** · 01-18-2013, 04:32 AM

Couple of possibilities

the wb variable could have lost its focus. Try replacing the line with

Please Login or Register  to view this content.

one of the links to be updated may be locked by user activities. If you keep getting this error it may be worth it to change your VBA code to loop through all existing links and update them individually. The advantage would be that you get to see which link is causing a problem. Is it always the same one, or a different one every time. What were you doing at the time of the error etc.

**galvinpaddy** · 01-18-2013, 04:35 AM

Good morning OllieB,

Thank-you for the suggestion, i will change the code to your idea and trial it, fingers crossed it works fine!
If not i will report back and seek further assistance!

Kind regards (again)

Run time error with auto update VBA code

LinkBack

Thread Tools

Rate This Thread

Display

Run time error with auto update VBA code

Re: Run time error with auto update VBA code

Re: Run time error with auto update VBA code

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions