Thre is an OLE Automation library referenced in both my Power Point and Excel
VBA. I'm not suure if that is included in the DLL. The DLL would only
included not standard items. OLE automation may be consider a standard
library in VB6 but not standard in Excel and Power Point.

"chris" wrote:

But the commands and references are included in DLL of VB6.. In Excel and
Power Point I just call form for showing OLE object..

"Joel" wrote:

The macro language in excel is slightly different in excel from other Office
products. You may need to set some References in the excel VBA menu Tools -
References. I would compare the references that arre enabled in Power Point
with the ones that are enabled in Excel.

"chris" wrote:


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!