Does Microsoft Excel 2003 support the use of multiple interfaces for a
single class? For example, can I select which interface to use (or
override the default interface) when creating a new instance of the
class.? What I am trying to do is use multiple interfaces to expose a
subsets of properties contain in a specific class

Thanks,

John C.

have a look at implements


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


wrote :

Does Microsoft Excel 2003 support the use of multiple interfaces for a
single class? For example, can I select which interface to use (or
override the default interface) when creating a new instance of the
class.? What I am trying to do is use multiple interfaces to expose a
subsets of properties contain in a specific class

Thanks,

John C.

According to Excel's documentation, the Implements statement must be
contained within the Class. What I want to do is use a different
Implements statement for the same Class code without having to
duplicate the Class several times. There does not appear to be a way
to override the Interface statement in the Class when creating a new
instance of the Class.

yep that would be correct, e.g.:

baseclass

derived class
implements baseclass

i'm sure i've known a way to give to give an instance
it's own classname at runtime.. can't remember nor find how.

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


wrote :

According to Excel's documentation, the Implements statement must be
contained within the Class. What I want to do is use a different
Implements statement for the same Class code without having to
duplicate the Class several times. There does not appear to be a way
to override the Interface statement in the Class when creating a new
instance of the Class.