Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I get a chart object (excel.ChartObject) from OLE_chart.object
I have procedures in VB6 for adding charts on excel worksheets. I use
variable EXL_CHRT (As excel.ChartObject) for setting source data etc. Now I created an OLE object on a form for chart preview before it is created. I can access it's worksheet with "OLE_chart.object.Worksheets(1)" for using my existing procedures for adding charts on worksheets. Can I get a chart object (As excel.ChartObject) from OLE_chart.object.Charts(1) in order to use existing procedures for setting chart settings ? ex. dim EXL_CHRT As excel.ChartObject SET EXL_CHRT = OLE_chart.object.Charts(1) EXL_CHRT.SetSourceData........ Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Method 'Height' of object 'ChartObject' failed | Excel Programming | |||
Select chart object in Excel 2007 | Excel Programming | |||
Using Microsoft Excel Chart object in VB6 | Charts and Charting in Excel | |||
Confusion about how the Window object fits into the Excel object model | Excel Programming | |||
Find and replace data in an Excel chart object | Charts and Charting in Excel |