links update
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
"Alex" wrote in
message
...
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
-----Original Message-----
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.
--
Regards,
Tom Ogilvy
"Alex" wrote in
message
...
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.
.
.
|