Consulting

Results 1 to 3 of 3

Thread: Sleeper: Do Not Update Links - On WB Open

  1. 05-13-2005, 12:07 PM #1
    stapuff
    stapuff is offline
    VBAX Contributor
    Joined
    Jun 2004
    Posts
    124
    Location

    Sleeper: Do Not Update Links - On WB Open

    Is there a way for the links to other workbooks not be updated on WB open?

    Thanks,

    Kurt


    Using xl2000
    Last edited by stapuff; 05-13-2005 at 12:09 PM. Reason: update information
    Reply With Quote Reply With Quote
  2. 05-13-2005, 12:37 PM #2
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    If you are opening the workbooks from code, you can use

    Workbooks.Open FileName:="YourFile.xls", UpdateLinks:=0
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber
    Reply With Quote Reply With Quote
  3. 05-13-2005, 02:15 PM #3
    stapuff
    stapuff is offline
    VBAX Contributor
    Joined
    Jun 2004
    Posts
    124
    Location
    xld -



    Thanks for the response. I figured after doing some research that I couldn't unless through another macro.

    Thanks again,

    Kurt
    Last edited by stapuff; 05-13-2005 at 02:16 PM. Reason: spelling
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules