I am having problems with my code that automates Excel 03 when applied to
Excel 07. The problem is in charting.

I use the following code (used in many prior versions of Excel) to set the
datalabels in an Excel chart that was created successfully:

oExcel.ActiveChart.SeriesCollection(1).DataLabels. Select

This line works fine in 03, but is coughing up an error €œData Type Mismatch
Expecting Object€� when run in Excel 07 (the chart itself does get constructed
successfully in 07). I checked and ActiveChart and SeriesCollection(1) are
defined objects, but Datalabels returns as empty and must be causing the
error since it cannot be selected.

I tried:
oExcel.ActiveSheet.ChartObjects("Chart 1").activate
oExcel.ActiveChart.SeriesCollection(1).DataLabels. Select

Which appears to be how a recorded macro would do it, but still the same
error message.

Anyone have a solution to this or even any ideas on what I might try.

Many thanks for any and all ideas,
Mark