Thread: Re: ActiveX control with chart

Hi Jon

Did you ever resolve this issue you discussed with Erich Neuwirth? I
have an almost identical problem: I've OLEembedded various activex
picture controls on worksheets, only to find I can't load images into
them, see images in them, or see their properties and methods.

I can activate an object using MyObject.Active, but this seems to
change nothing. I can select an OLEObject with MyObject.Select, but
then using With Selection, the tipswindow only shows the sheet
properties, not the OLEobject properties.

As you say, it seems like all Excel can see is the Shape that encloses
the control. I'd be extremely grateful for any help from anyone.



Jon Peltier wrote:
> [B]Hi Erich -
>
> Last year I installed a third party ActiveX chart control, thinking
> I'd
> use it for some funky new charts. Five minutes ago I used it for the
> first time, to get a handle on your question. I insert the chart
> using
> Insert menu > Object, and selecting it from the list.
>
> I could activate the control's dialog with the right button, but
> otherwise I couldn't select or activate the control. The best I could
> do
> in vba was to change its position (activesheet.shapes(1).top and
> .left)
> and its size (.width and .height) but not its aspect ratio.
>
> Then I switched to design mode (click the quaint T-square and
> triangle
> button on Excel's Visual Basic command bar). This enabled me to
> select
> the objects, move and size it with the mouse, and change the aspect
> ratio.
>
> Interestingly, as soon as I ran something from the VB Editor, Excel
> exited design mode, and VB was unable to do very much. Excel created
> a
> reference to the control, but for the life of me, I could see
> nothing
> that talked of a container for the control. I suspect the container
> is
> just a nondescript Shape.
>
> Seems like all Excel can see is the Shape that encloses the control.
>
> - Jon



--
Tanihera
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message953530.html

A blast from the past. I suspect I gave up on the ActiveX charting control,
since I don't remember anything further.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"Tanihera" <Tanihera.263k60@mail.mcse.ms> wrote in message
news:Tanihera.263k60@mail.mcse.ms...
>
> Hi Jon
>
> Did you ever resolve this issue you discussed with Erich Neuwirth? I
> have an almost identical problem: I've OLEembedded various activex
> picture controls on worksheets, only to find I can't load images into
> them, see images in them, or see their properties and methods.
>
> I can activate an object using MyObject.Active, but this seems to
> change nothing. I can select an OLEObject with MyObject.Select, but
> then using With Selection, the tipswindow only shows the sheet
> properties, not the OLEobject properties.
>
> As you say, it seems like all Excel can see is the Shape that encloses
> the control. I'd be extremely grateful for any help from anyone.
>
>
>
> Jon Peltier wrote:
>> [B]Hi Erich -
>>
>> Last year I installed a third party ActiveX chart control, thinking
>> I'd
>> use it for some funky new charts. Five minutes ago I used it for the
>> first time, to get a handle on your question. I insert the chart
>> using
>> Insert menu > Object, and selecting it from the list.
>>
>> I could activate the control's dialog with the right button, but
>> otherwise I couldn't select or activate the control. The best I could
>> do
>> in vba was to change its position (activesheet.shapes(1).top and
>> .left)
>> and its size (.width and .height) but not its aspect ratio.
>>
>> Then I switched to design mode (click the quaint T-square and
>> triangle
>> button on Excel's Visual Basic command bar). This enabled me to
>> select
>> the objects, move and size it with the mouse, and change the aspect
>> ratio.
>>
>> Interestingly, as soon as I ran something from the VB Editor, Excel
>> exited design mode, and VB was unable to do very much. Excel created
>> a
>> reference to the control, but for the life of me, I could see
>> nothing
>> that talked of a container for the control. I suspect the container
>> is
>> just a nondescript Shape.
>>
>> Seems like all Excel can see is the Shape that encloses the control.
>>
>> - Jon
>
>
>
> --
> Tanihera
> ------------------------------------------------------------------------
> Posted via http://www.mcse.ms
> ------------------------------------------------------------------------
> View this thread: http://www.mcse.ms/message953530.html
>