Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Update links | Excel Discussion (Misc queries) | |||
update links | Excel Discussion (Misc queries) | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
Update links | Excel Discussion (Misc queries) | |||
can't update links...can't find links | Excel Discussion (Misc queries) |