Refresh linked with excel object using VBA

[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

 

[Shyam Pillai]

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

 

[sweet_dreams]

It works great. Thanks a lot.

Regards,
Sebastian