Call C# class from VBA

Question

Please can some1 tell me as to what is wrong with my code?

C#:

namespace ComMsg
{
[InterfaceType(ComInterfaceType.InterfaceIsIDispatch)]
public interface IM
{
    [DispId(1)]
    event M.MHandler OnMSend;
}

[InterfaceType(ComInterfaceType.InterfaceIsIDispatch)]
public interface IMEvents
{
    [DispId(2)]
    void sendM(M.Process status, string msg);
}

[ComSourceInterfaces(typeof(IM), typeof(IMEvents))]
[ClassInterface(ClassInterfaceType.None)]
public class Message : IM
{
    public enum Process { Error, Complete }

    public delegate void MHandler(Process status, string msg);
    public event MHandler OnMSend;

    public void sendM(Process status, string msg)
    {
        if (OnMSend != null)
            OnMSend(status, msg);
    }
}
}

I call this from my VBA code

Private WithEvents moCom     As ComMsg.M

Public Function Run() As Boolean
Set moCom = New ComMsg.M

it fails at

New ComMsg.Message

and i get an error message

"Object or class does not support the set of events"

Please help to resolve this issue. Thanks

possible duplicate of C# to VB6 COM events ("object or class does not support the set of events") — Jon Egerton
– Jon Egerton, Commented Aug 21, 2012 at 21:35
VBA is usually pretty cranky about interfaces that are not marked as [default]. Try declaring only one event interface. — Hans Passant
– Hans Passant, Commented Aug 21, 2012 at 22:19
whenever i pass parameters (Process status, string msg) it gives me an error.. any suggestions??? without parameters it works fine — user175084
– user175084, Commented Aug 22, 2012 at 17:09

Jon Egerton · Accepted Answer · 2012-08-21 21:51:01Z

1

Looks like you're missing quite a lot of the settings required to implement COM interop. The suggested duplicate link addresses a similar issue.

It might also be worth looking at the MSDN Com interop example here for all the various settings you need to include to use COM interop.

edited Aug 21, 2012 at 21:51

answered Aug 21, 2012 at 21:37

Jon Egerton

41.8k11 gold badges100 silver badges130 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user175084 Over a year ago

I have edited my C# code but i still get the error. Please have a look. Thanks

user175084 Over a year ago

whenever i pass parameters (Process status, string msg) it gives me an error.. any suggestions??? without parameters it works fine

Collectives™ on Stack Overflow

Call C# class from VBA

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related