Solved

How Do I Suppress The Update Links Prompt In Word 2003

Posted on 2007-03-27
3
536 Views
Last Modified: 2012-06-21
I have a Word 2003 document with about 25 linked Excel spread sheets.  When I open the Word document I get the "This document contains links..." prompt asking me if I want to update the links.  I would like to suppress this message and just have the links always update every time I open the Word document.  Please note ... I have the links set to "Automatic" already and have the Tools|Options|General setting set to on for "Update Automatic Links on Open".
0
Comment
Question by:modtodd
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 14

Accepted Solution

by:
Glenn_Moore earned 125 total points
ID: 18801301
Try the following code:
Sub Document_Open()
Application.DisplayAlerts = False
    With Options
        .UpdateLinksAtOpen = True
    End With
Selection.WholeStory
Selection.Fields.Update
Selection.HomeKey
End Sub
0
 
LVL 14

Expert Comment

by:Glenn_Moore
ID: 18801311
0
 

Author Comment

by:modtodd
ID: 18809500
I am implementing this through an API call in Delphi and based on the posted comment I was able to code the solution.  My code looks like the following

    WordDocumentResearch.Open;
    WordApplicationResearch.WordApplication.DisplayAlerts := 0;
    WordApplicationResearch.WordApplication.Options.UpdateLinksAtOpen := True;

Thank You
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My experience with Windows 10 over a one year period and suggestions for smooth operation
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question