Refresh linked with excel object using VBA

  • Thread starter Thread starter sweet_dreams
  • Start date Start date
S

sweet_dreams

Dear All,

Recently I stumbled upon such a problem: I have power point
presntation (pp 2000) which contains approxamately 50 slides. On each
slide there are tabels and charts. This objects are linked from excel.
My question is how can I automaticaly refresh these objects so that I
won't have to refresh them manually. I tried to record macro while
refreshing but it seems that PP doesn't generate all code like it's in
Excel or Word.
I would be grateful for any suggestions.

Regards,
Sebastian
 
This should do it.

'------------------------------------------------------------
Sub UpdateLinkedObjects()

Dim oShp As Shape
Dim oSld As Slide
For Each oSld In ActivePresentation.Slides
For Each oShp In oSld.Shapes
If oShp.Type = msoLinkedOLEObject Then
oShp.LinkFormat.Update
End If
Next
Next

End Sub
'------------------------------------------------------------
Regards,
Shyam Pillai
 
Back
Top