Refresh linked with excel object using VBA

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



"sweet_dreams" <sweet_dreams.TakeThisOut@o2.pl> wrote in message
news:f67da65a-eb4b-47d3-9f9a-5f34bcd62dc8@l42g2000hsc.googlegroups.com...
> 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