How do you disable updating of links through VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

moodypete@hotmail.com - 30 Jul 2007 19:27 GMT

Hi,

I am working on an app which (among other things) is resonsible for
making a PDF of Word docs. That PDF part is fine.

The problem is, the Word docs often contains OLE links for which the
source is not available. When my print routine opens these docs, the
links are converted to "Error! Not a valid link." in the same way that
happens when I choose 'Update Links' when opening a Word doc that
contains missing links, through Word.

My printing routine is very simple. I just call Open(),
PutActivePrinter() amd PrintOut(). My question is: is there any way to
open a word doc in VBA and force Word to explicitly not update links?

Thx in advance.

Peter

Reply to this Message

Doug Robbins - Word MVP - 31 Jul 2007 01:44 GMT

Dim i As Long
With ActiveDocument
For i = .Fields.Count To 1 Step -1
.Fields(i).Unlink
Next i
End With

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi,
>
[quoted text clipped - 14 lines]
>
> Peter

Reply to this Message

old man - 31 Jul 2007 01:48 GMT

Hi,

Run this:

application.Options.UpdateLinksAtOpen = false

Old Man

> Hi,
>
[quoted text clipped - 14 lines]
>
> Peter

Reply to this Message