LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update links wcurtis Excel Discussion (Misc queries) 1 January 13th 09 07:10 PM
update links Ed Jones Excel Discussion (Misc queries) 0 May 1st 08 06:20 PM
Update links box gives Continue or Edit Links dialog KarenF Excel Discussion (Misc queries) 0 May 18th 07 01:17 PM
Update links Brisbane Rob Excel Discussion (Misc queries) 2 November 25th 05 07:44 PM
can't update links...can't find links GJR3599 Excel Discussion (Misc queries) 1 April 4th 05 04:56 PM


All times are GMT +1. The time now is 04:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"