Re: VBA Command to Refresh Excel Charts in Word 2007?

Tech-Archive recommends: Speed Up your PC by fixing your registry

If it is OK to update all of the fields in the document, then use

ActiveDocument.Fields.Update

If you only want to update Links in the document, then use

Dim alf as Field
For each alf in ActiveDocument.Fields
If alf.Type = wdFieldLink then
alf.Update
End if
Next

--
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

"Paul M. Eldridge" <paul.eldridge@xxxxxxxxxxxxxxx> wrote in message
news:3m3644t2g6ivutfa58u7sard9srnq1goo1@xxxxxxxxxx
I've linked a couple of Excel charts to a Word document and would like
to have VBA refresh these charts on demand (the update method for this
particular Word document is set to manual).

Using the mouse, I can click on the Office Button - Prepare - Edit
Links to Files, highlight the source files to be updated and click
Update Now, then Close to return to the document. Unfortunately, the
macro recorder does not allow me to record these keystrokes and I'm at
a loss as to the correct VBA commands and structure. Could anyone
point me in the right direction?

With much thanks,
Paul


.

Quantcast