Thread: links update
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
alex alex is offline
external usenet poster
 
Posts: 25
Default links update

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.