B
bucweat
Hi,
I've got some VBA code running in some VBScript classes that works in
Excel 2000 and 2003 (or excel versions 9 and 11) that identifies a
series object in the following way (assume taht oMyChart points to a
valid chart object):
set oSeries = oMyChart.SeriesCollection("MyChartSeries")
msgbox oSeries.name
I know that "MyChartSeries" is a valid series name as the following
code tells me (works in 2000,2003,2007):
for each oSeries in oMyChart.SeriesCollection
msgbox oSeries.Name
next
Is there something wrong with the way SeriesCollection works on 2007?
I can't believe there is something I'm doing wrong here as it does
work in the other versions just fine (famous last words I know...). I
can not find any examples on the net where a name is used for index.
Signed, "In VBA hell..."
I've got some VBA code running in some VBScript classes that works in
Excel 2000 and 2003 (or excel versions 9 and 11) that identifies a
series object in the following way (assume taht oMyChart points to a
valid chart object):
set oSeries = oMyChart.SeriesCollection("MyChartSeries")
msgbox oSeries.name
I know that "MyChartSeries" is a valid series name as the following
code tells me (works in 2000,2003,2007):
for each oSeries in oMyChart.SeriesCollection
msgbox oSeries.Name
next
Is there something wrong with the way SeriesCollection works on 2007?
I can't believe there is something I'm doing wrong here as it does
work in the other versions just fine (famous last words I know...). I
can not find any examples on the net where a name is used for index.
Signed, "In VBA hell..."