Solved

How Do I Suppress The Update Links Prompt In Word 2003

Posted on 2007-03-27
3
531 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
  • 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Retrieve Windows Office Files from Parallels 12 VM 9 73
Changing Comments author in Word 2010 10 28
Word macro referencing data 8 30
Can not open the Access Help ? 3 55
This is written from a 'VBA for MS Word' perspective, but I am sure it applies to most other MS Office components where VBA is used.  One thing that really bugs me is slow code, ESPECIALLY when it's mine!  In programming there are so many ways to…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

831 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