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 15:32:31 -0400

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" <anonymous@discussions.microsoft.com> wrote in message
news:5f0101c4816b$06272910$a601280a@phx.gbl...
> 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" <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: 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: links update
    ... the lowest level of a chain of links first and work upward in a breadth ... which have links through LookUp ... > function with many other books Book1,Book2,... ... > Set xlbook = xlapp.Workbooks.Open ...
    (microsoft.public.excel.programming)
  • 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)