C
chris
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!
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!