How to get the charts with in container

[krishnaroopa]

Hi all

I have a sheet and trying to get the all charts in the sheet. Used ActiveSheet.getSheetObjects and checked the object type and able to get the charts

But when the charts are placed in a container object, the charts are not retrieved by getSheetObjects method and also not listed in the

Settings > Sheet Properties > Objects list.

How to get those chart objects too?

[rajni_batra]

Use container ID to activate Sheet Object.

Regards

Rajni