Posted By

sjmoorecouk on 10/25/12

Tagged

Versions (?)

Last Edited at 10/25/12 02:53am

Statistics

Viewed 121 times

Favorited by 0 user(s)

Related snippets

Linked Chart Update

/ Published in: Visual Basic

Relinks chart objects to a new source (where newfile is the variable containing that new full path/file source info)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

Dim thisShape As Word.Shape
Dim x as Long
UpdateCharts:
On Error Resume Next
For Each thisShape In ActiveDocument.Shapes
x = x + 1
If thisShape.Type = msoLinkedOLEObject Then
   With thisShape.LinkFormat
    .SourceFullName = newFile
    StatusBar = x & " of " & TotalFieldCount & " links completed ..."
End With

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.