Matt -

Is it a chart that you will need to update? I've found OLEFormat to be
(a) slow, and (b) incomprehensible. Rather than using this approach
with charts embedded in other applications, I've found it easier to redo
the chart in Excel, then replace the old one in the other app with the
new one. This is done with shapes, which is easier than OLE stuff.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Matt Tessar wrote:
Hello,

I have an application that adds charts into powerpoint
using the AddOLEObject function. When I attempt to assign
the recently added object to a variable of type
Excel.Chart from the shape.OLEFormat.Object property , it
takes quite a while. This assignment/cast seems to take
about 1 second to complete. Does anyone know why this is
so slow? Is there a different way to access the pointer
to the chart than using the OLEFormat.object property? Is
there a way to speed this up?

Thanks
Matt