Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default activechart.axes not in 2007 - what's the replacement?

I've got an older VB application that works fine with 2003. We've
upgraded to 2007 and it no longer works. In 2003 there was an
activechart.axes method. This has been changed and I need to find out
what the replacement method(s) might be.

tia
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,489
Default activechart.axes not in 2007 - what's the replacement?

Hi,

Axes is still part of the charts OM.

Can you post the code you are using and explain exactly what error you
get and where.
Also is the sheet protected in anyway?

Cheers
Andy

oaksong wrote:
I've got an older VB application that works fine with 2003. We've
upgraded to 2007 and it no longer works. In 2003 there was an
activechart.axes method. This has been changed and I need to find out
what the replacement method(s) might be.

tia


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default activechart.axes not in 2007 - what's the replacement?

On Sep 4, 3:54*am, Andy Pope wrote:
Hi,

Axes is still part of the charts OM.

Can you post the code you are using and explain exactly what error you
get and where.
Also is the sheet protected in anyway?

Cheers
Andy

oaksong wrote:
I've got an older VB application that works fine with 2003. We've
upgraded to 2007 and it no longer works. In 2003 there was an
activechart.axes method. This has been changed and I need to find out
what the replacement method(s) might be.


tia


--

Andy Pope, Microsoft MVP - Excelhttp://www.andypope.info


Hi. Just got back from vacation.

After a bit of experimentation it turned out that .Axes was ok, it was
just that he specific axis being referred to didn't exist. I didn't
write the code so I don't know where it went or why, something I'll
have to find an answer for.

Thanks anyway
Reply
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
setting ActiveChart.Axes(xlCategory).MinimumScale not working Teddy[_3_] Excel Programming 2 April 26th 09 09:57 PM
Excel 2007 ActiveChart formatting erases graph Mbballfan Excel Programming 0 July 31st 08 10:03 PM
MS Excel 2007. ActiveChart.ApplyCustomType Jul Excel Programming 0 January 18th 08 06:56 PM
ActiveChart.Axes(xlValue).Crosses = xlMinimum Stacy35216[_4_] Excel Programming 4 August 17th 05 03:51 PM
Argument List Of ActiveChart.Location And ActiveChart.ChartType Mo[_3_] Excel Programming 2 September 1st 03 11:12 PM


All times are GMT +1. The time now is 05:32 PM.

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

About Us

"It's about Microsoft Excel"