Results 1 to 2 of 2
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Automatic Open Of Linked Files (2000)

    Is there a shortcut that would automatically open linked files (and linked files within linked files) without having to go through the prompt process?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Automatic Open Of Linked Files (2000)

    You can put in the workbook open code to not display alerts which will accept the default to update, then turn them back on afterwards.

    Application.DisplayAlerts = False

    Or if you are opening then with code (Workbooks.open)there is an UpdateLinks parameter
    <hr>
    Value Meaning
    0 Doesn't update any references
    1 Updates external references but not remote references
    2 Updates remote references but not external references
    3 Updates both remote and external references<hr>

    Steve

Posting Permissions

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