If I follow, in your form load event you are doing something like
Set cht = Me.OLE1.object.Charts(1)
where 'object' is an Excel chart object in the OLE container
How is the
VB dll compiled, eg ActiveX or something else
How have you installed or run the dll in Excel
When and where from is the series data sourced.
Regards,
Peter T
"chris" wrote in message
...
I created it with 2 ways. With insertable object of Excel chart and with
OLE
Container Control. The messages below are for OLE Container Control.
DLL with insertable object, called in Excel needs user to double-click on
chart object to see chart..
DLL with OLE Container Control, called in Excel is blank, while it has
values..
DLL with insertable object, called in Power Point gives error.
DLL with OLE Container Control, called in Power Point works ok.
"Peter T" wrote:
How did you create the Excel Chart as an OLE on a VB6 form
Regards,
Peter T
"chris" wrote in message
...
In VB6 I created a DLL with a form including an OLE object with
Microsoft
excel chart.
When I call this DLL in Excel for showing form, OLE object is blank. It
has
data, title etc, I can retrieve their values but cannot see them in OLE
object.
When I call same DLL in Power Point for showing form, OLE object works
ok.
Is there any solution for Excel to see chart of OLE object ?
Thanks a lot in advance!