In the Create class dialog choose Ole Control. Then choose your control.
>Dear All,
>
>I tried to subclass activex Excel worksheet within container
>and this worked, BUT when I add it to the form, and try to fill up some excel values (design time) values are lost after form is saved/closed.
>
>If I add plain ActiveX to the form then excel values are saved normally.
>
>My next idea was to try to subclass activex without parent container
>and then realised that I don't know how to do it. Aldough help states that activex can be subclassed I just simply don't know how to do it.
>
>My Goal is to add few properties and methods to excel activex,
>but then when add it and use it in the form - to also keep excel values entered at design time.
>
>Any help is greatly appreciated.
>TIA
>
>Any
If it's not broken, fix it until it is.
My Blog