Hi Tom

Yes, that sounds like a good solution. I'll give it a try.

Thanks

Paul




Tom Ogilvy wrote:

I haven't run into it, so I don't have a tested workaround, but here is a
thought:

did the LinkSources list change? if not, you could get the list again
(after the change) and compare to the original list - if they haven't
changed, you know you have a problem. Or compare the new list to see it
the desired change is included.


--
Regards,
Tom Ogilvy

"Paul Martin" wrote in message
ups.com...
Hi all

I have written some code that loops through the links in a workbook and
updates them to different paths. To be more specific, it updates the
paths from drive letters to UNC paths.

Generally, this works, but fails where the new path forces formulae in
the workbook to exceed Excel's 1024 character limit. Interestingly,
the link update fails, but it raises no error, so there's not an
automatic means of determining that one or more links has failed to
update.

I would like to know after the code has completed whether any updates
have failed. Does anyone have a fix or workaround for this?

Thanks in advance

Paul Martin
Melbourne, Australia