LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default seriescollection(name) not working in excel 2007

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..."

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
F2 Key not working in Excel 2007 JodieM Excel Discussion (Misc queries) 2 November 18th 10 08:21 PM
click right not working in Excel 2007 JP Excel Discussion (Misc queries) 1 February 12th 09 03:10 PM
Excel 2007 Macro Help (Excel 2003 not working in 2007) Pman Excel Discussion (Misc queries) 4 May 29th 08 06:29 PM
excel 2007 Seriescollection.Add bug [email protected] Excel Programming 1 August 28th 07 04:58 AM
Excel 2007 links not working Mary Excel Discussion (Misc queries) 1 December 11th 06 10:12 PM


All times are GMT +1. The time now is 05:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"