Hiding Methods in Automation Add-In

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Matthew Wieder - 22 Jun 2006 22:03 GMT

In VS 2005 and Excel 2003. I am writing an Automation Add-In in C# and don't
want to expose the Object methods (GetHashCode, GetType etc.) to end users to
put in their cell formulas. A post here
http://groups.google.com/group/microsoft.public.dotnet.framework.interop/browse_
frm/thread/fbc3f32a59e8b9e1/d036a59ead000e62?

suggests marking the class as ClassInterfaceType.None and implementing a
public interface with just the desired methods but this does not work (maybe
it worked in .NET 1.1). Help?

Reply to this Message

Dmytro Lapshyn [MVP] - 23 Jun 2006 11:22 GMT

Hi Matthew,

Check that the public interface is marked as
ComInterfaceType.InterfaceIsDual or at least
ComInterfaceType.InterfaceIsDispatch (with the [InterfaceType] attribute).

Signature

Regards,
Dmytro Lapshyn [MVP]
http://blogs.vbcity.com/DmytroL

> In VS 2005 and Excel 2003. I am writing an Automation Add-In in C# and
> don't
[quoted text clipped - 7 lines]
> (maybe
> it worked in .NET 1.1). Help?

Reply to this Message

Matthew Wieder - 23 Jun 2006 13:31 GMT

The interface is set to dual - the functions still do not show up in the
Insert Function dialog in Excel. Does anyone have this working in .NET 2.0?

> Hi Matthew,
>
> Check that the public interface is marked as
> ComInterfaceType.InterfaceIsDual or at least
> ComInterfaceType.InterfaceIsDispatch (with the [InterfaceType] attribute).

Reply to this Message

Matthew Wieder - 23 Jun 2006 14:53 GMT

Solved it - Based on web examples, I had been implementing my class as:

public class myClass : Object, MyInterface, Extensibility.IDTExtensibility2

which makes the primary interface the object type and that was causing
the problems. Changed to:
public class myClass : MyInterface, Extensibility.IDTExtensibility2

and only the desired methods are showing in Excel now.

thanks.

> The interface is set to dual - the functions still do not show up in the
> Insert Function dialog in Excel. Does anyone have this working in .NET
[quoted text clipped - 6 lines]
>> ComInterfaceType.InterfaceIsDispatch (with the [InterfaceType]
>> attribute).

Reply to this Message

Hiding Methods in Automation Add-In

Free Magazines