Re: links update

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

From: Alex (anonymous_at_discussions.microsoft.com)
Date: 08/13/04 

Date: Fri, 13 Aug 2004 12:23:33 -0700

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. ... >>Tom Ogilvy ... >>> books have thier own links through LookUp with MainBook ...
    (microsoft.public.excel.programming)
  • 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)
  • 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: 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)