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!

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!

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!

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!

Unfortunately OLE Automation library is included in DLL, in Excel workbook &
Power Point... In Excel all commands work without any problem, it's just that
OLE object does not show chart...

it seems there is a conflict of OLE object including excel.chart and DLL
being called in Excel...

How did you create the Excel Chart as an OLE on a VB6 form

Regards,
Peter T

"chris" <(E-Mail Removed)> wrote in message
news:9437B30C-4DC4-4C13-B810-(E-Mail Removed)...
>
> 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!

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" <(E-Mail Removed)> wrote in message
> news:9437B30C-4DC4-4C13-B810-(E-Mail Removed)...
> >
> > 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!
>
>
>

DLL with insertable object and with OLE Container Control, called in Power
Point work ok. My mistake..

Problem is in Excel..

The reason I am trying it from DLL is that I have 2 add-ins, one for Excel &
one for Power point and I am trying to remove duplicate programming code.
Till now I have same code in both add-ins for chart preview. ex. in Excel, I
have a hidden workbook with a chart, from which I export picture of chart
and I assign it to a picture so user has preview of chart before is created.

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" <(E-Mail Removed)> wrote in message
news:4C4BEC73-C8A7-48FD-AFCF-(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
>> news:9437B30C-4DC4-4C13-B810-(E-Mail Removed)...
>> >
>> > 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!
>>
>>
>>

Yes, for OLE Container Control I use

Set chrt = ole1.object.Charts(1)
Set exl_WKS = ole1.object.Worksheets(1)

and for insertable object of Excel chart I use

Set chrt = Chart1.object.Charts(1)
Set exl_WKS = Chart1.object.Worksheets(1)

DLL is compiled as ActiveX DLL.

In form load I am assigning some test data for both charts in the worksheet
object retrieved (see above).

exl_WKS.Cells(1, 2).Value = "a"
exl_WKS.Cells(1, 3).Value = "b"
exl_WKS.Cells(2, 2).Value = 500

exl_WKS.Names.Add Name:="Chart_Range", RefersToR1C1:="=" & "R" & "1" & "C"
& "1:" & "R" & "2" & "C" & "3"

exl_chrt.SetSourceData Source:=exl_WKS.Range("Chart_Range"),
PlotBy:=xlRows