PDA

View Full Version : Find Embedded chart excel objects



balumail75
06-14-2011, 04:36 AM
Hello all,

How to find in powerpoint vba, whether the shape is an "embedded excel chart object"? I used msoEmbeddedOLEObject, but it runs for all embedded objects like photoeditor photo object, word object. I am converting all the embedded excel chart as pictures.

Please help me...

Reg,
Balu.

Cosmo
06-14-2011, 05:19 AM
I believe you can check the TypeName of the shape. Assuming a shape referenced by variable 'oShape':

typename(oShape.OLEFormat.Object)