LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 788
Default Can I get a chart object (excel.ChartObject) from OLE_chart.ob

Thanks Peter.

I use the commands below for accessing a chart in OLE object.

Dim exl_chrt As Excel.Chart

Set exl_chrt = ole_excel_chart.object.Charts(1)

My existing procedures had a parameter to CHARTOBJECT instead of CHART.
That's why I was trying to retrieve the CHARTOBJECT from the 2 types of
charts I was creating. I changed parameter to be CHART and retrieve chart
object for both charts and it works.



 
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
Method 'Height' of object 'ChartObject' failed Anand Nichkaode Excel Programming 1 November 20th 08 11:08 AM
Select chart object in Excel 2007 Luca Brasi Excel Programming 4 August 29th 07 02:55 PM
Using Microsoft Excel Chart object in VB6 fizbim Charts and Charting in Excel 0 July 13th 05 05:14 PM
Confusion about how the Window object fits into the Excel object model Josh Sale Excel Programming 11 April 15th 05 06:08 PM
Find and replace data in an Excel chart object Cawen Charts and Charting in Excel 2 March 31st 05 06:47 PM


All times are GMT +1. The time now is 08:44 AM.

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"