Re: links update

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 08/13/04 

Date: Fri, 13 Aug 2004 14:33:33 -0400

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" <anonymous@discussions.microsoft.com> wrote in message
news:593d01c48161$b2e61350$a301280a@phx.gbl...
> 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.

Relevant Pages

  • Re: links update
    ... I have a situation when cells A1:A100 from the MainBook ... Everything is through LookUp. ... >the lowest level of a chain of links first and work ... >> books have thier own links through LookUp with MainBook ...
    (microsoft.public.excel.programming)
  • links update
    ... I have some MainBook, which have links through LookUp ... function with many other books Book1,Book2,... ... Set xlbook = xlapp.Workbooks.Open ...
    (microsoft.public.excel.programming)
  • Re: links update
    ... I have a situation when cells A1:A100 from the MainBook ... Everything is through LookUp. ... >>Tom Ogilvy ... >>> books have thier own links through LookUp with MainBook ...
    (microsoft.public.excel.programming)
  • Re: Search Form - text string.
    ... I believe I'm going to head out get one of your books. ... So if I do not use Lookup fields what should I use? ... than trying to teach me the basics on a newsgroup. ... Can repeat for any individual search using a combobox to ...
    (microsoft.public.access.formscoding)
  • Re: A database design question
    ... As far as being able to sort on Author's Name, I exactly did what you are ... I want to see my books by title or by author name. ... > lookup functionality and requires you to write the lookup code by hand ... > To be able to sort on Author's Name, you would need to add the rendundant ...
    (comp.lang.pascal.delphi.misc)