Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Location
    Melksham, Wiltshire, England
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Open Workbook with links. (windows 2000)

    I have anumber of workbooks that have links between them. I know its possible in VBA to open one workbook from another without getting the "Do you want to update links" message. I would like to know if its also possible to open a workbook from the file menu 'Open' command without getting this message.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Open Workbook with links. (windows 2000)

    The Edit tab of Tools | Options... contains an option "Ask to Update Links" or something similar (I don't know the exact caption in English). If you clear the check box, Excel won't ask about updating links. You can set this in VBA as follows:

    Application.AskToUpdateLinks = False.

    If you don't want to change the setting permanently, you can get the setting before, and restore it after opening a workbook:

    Dim fSetting As Boolean
    fSetting = Application.AskToUpdateLinks
    Application.AskToUpdateLinks = False
    Workbooks.Open "Test.xls"
    Application.AskToUpdateLinks = fSetting

  3. #3
    New Lounger
    Join Date
    Jul 2002
    Location
    Melksham, Wiltshire, England
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Open Workbook with links. (windows 2000)

    Thanks Hans This does the trick nicely

    Jim

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •