Re: Existing Excel Addin crashes in Excel 2007

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Dave,

Since you haven't gotten a response here, try asking in the more
specialized excel.programming newsgroup. The folks there may have
run into this during beta and know what's going on. The charting
engine was changed so extensively, you'll probably come across
quite a few things that no longer function the same...

I have an existing Excel addin written several years ago,
which has worked without changes on Excel 97, 2000 & 2003.

With Excel 2007, it gets a run-time error '438':
"Object doesn't support this property or method."

I have tracked it down to this line of code:
For Each pnt In ech.ChartGroups(1).SeriesCollection(1).Points

where the data items are defined as:
Dim pnt As Excel.Point
Dim ech As Excel.Chart

and after ChartWizard has been called to create a 3DPie chart.

Any ideas why this should happen and how to fix it?


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17
2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :-)

.

Relevant Pages

  • Re: Existing Excel Addin crashes in Excel 2007
    ... I got it to work by extracting a block of the code from the function ... and defining it as a separate function, ... Dim pnt As Excel.Point ... This reply is posted in the Newsgroup; ...
    (microsoft.public.office.developer.automation)
  • Re: Question re. Global Warming
    ... Graham, I only wish it were a big Goose Egg. ... Unix or one of its clones on a softare newsgroup. ... filling the mailbox every 10 minites. ... Evidently several folks here have taken exception to my legitimate ...
    (sci.energy.hydrogen)
  • Re: Removing IE 7 Beta Caused Problems
    ... Add/Remove Programs as is the suggested method or removal, ... Replies are posted only to the newsgroup for the benefit or other readers. ... Well, this problem is not really one with IE 7 beta, is it? ... also...all IE7 Beta 2 Public Preview testers are asked to post their ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: Lessons learned
    ... I though he was being nice, I almost told ya to get rid of the bike before you killed yourself.......but was busy packing to ride over to the coast for a party with some folks I met here..... ... You have no fucking idea what the intent of this newsgroup is, ... Mr. Chilly may be surprised, since he doesn't qualify, but there are people who enjoy helping other people while they waste their time on the net. ... If you want to solve a problem involving trigonometry, and I know how, I'm not going to tell you to go buy a trig book or take a trig course. ...
    (rec.motorcycles.harley)
  • Re: Microsoft.DirectX.AudioVideoPlayback in NET 2.0
    ... http://www.thezbuffer.com - News and information for Managed DirectX ... I still do not have access to the beta news group server. ... They need an SDK to cover what SDK to use for ... raise that in the beta newsgroup. ...
    (microsoft.public.win32.programmer.directx.managed)