links update

[Alex]

I have some MainBook, which have links through LookUp
function with many other books Book1,Book2,... . Those
books have thier own links through LookUp with MainBook as
well. AnotherBook have links (through LookUp) with those
books (Book1,...) too.

I'm douing the links update from MS Access.
I'm trying to do it by using the following for all these
books:

xlapp.AskToUpdateLinks = False
Set xlbook = xlapp.Workbooks.Open(...)

With xlbook

.UpdateLink Name:=xlbook.LinkSources

End With

Please, advise whether it's enough to have those links
updated.

Thanks in advance.

 

[Tom Ogilvy]

There will be no ripple effect, so you would need to open the workbooks at
the lowest level of a chain of links first and work upward in a breadth
first manner.

 

[Alex]

Thanks a lot, Tom.
However, in this case, I need to ask you the following
questions:

1. Should all these books be opened during this time?
2. I have a situation when cells A1:A100 from the MainBook
are linked to the cell B1 in Book1,Book2, ... and cell D1
from those Book1,Book2 is linked to some specific cell
from column H of MainBook. Everything is through LookUp.
Will all these links be updated in this case?

Regards,

Alex

 

[Tom Ogilvy]

If you have circular links such as you describe, then you would need all the
workbooks open at the same time I would think. This would be the
safest/surest in any event.

 

[Alex]

Thank you very much again, Tom.

-----Original Message-----
If you have circular links such as you describe, then you would need all the
workbooks open at the same time I would think. This would be the
safest/surest in any event.

--
Regards,
Tom Ogilvy




.