+ Reply to Thread
Results 1 to 2 of 2

Prevent updating links on workbook open in VBA

  1. #1
    Registered User
    Join Date
    11-18-2012
    Location
    Longmont, CO
    MS-Off Ver
    Excel 2007
    Posts
    1

    Prevent updating links on workbook open in VBA

    When opening workbooks with VBA in Excel 2007 that contain links to other workbooks, I want to eliminate the message box requesting the selection of "Continue" or "Edit Links" and have it default to "Continue". I have tried using the parameter "UpdateLinks:=2" as specified in the VBA Developer Reference, but still receive the message box. Any suggestions?

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Prevent updating links on workbook open in VBA

    if you use the updatelinks:=2 that should get rid of the message box? What code are you using? Note, generally one way to get rid of messageboxes is to set displayalerts equal to false which will select the default response to all user prompts. That would be one option in this case but remember to set it back to true afterwards, for example:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    11-18-2012
    Location
    Longmont, CO
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Prevent updating links on workbook open in VBA

    Thanks for the fast response! Here's the code I'm using:

    Workbooks.Open Filename:= HistFileName, UpdateLinks:=2

    where HistFileName is a full-qualified file name.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Updating links to a workbook that isnt open?
    By theduv1 in forum Excel General
    Replies: 0
    Last Post: 12-20-2010, 02:16 PM
  2. Prevent excel from updating external file links
    By Dulanic in forum Excel General
    Replies: 1
    Last Post: 11-16-2010, 05:25 PM
  3. Updating Links on Open
    By johncassell in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-25-2005, 09:23 AM
  4. [SOLVED] Links not updating unless the source is open...
    By John Keith in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-12-2005, 07:06 PM
  5. prevent error on workbook open (links could not be updated)
    By neowok in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-28-2005, 11:22 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1