Scouring reports with embedded charts

[bill]

Hey,

I've inhereted an MDB filled chart embedded with reports.
I wish to copy the charts into EXCEL.
I assume I can scour the reports and pick up the graph properties.
Then, I'll feed properties to EXCEL vba to create the graphs on the fly.

I can iterate through the reports.
I can iterate through the controls of a report.

I cannot determine if the control is a chart.

Please help.

 

[bill]

OK, the darned control has properties not exposed by the "."

Like
.NAME
.CONTROLTYPE

The graphs appear to be of control type 114