Getting Type Mismatch Error while passing Array of Interfaces from C#(VSTO) to VBA through IDispatch interface.

See more:

C#

.NET

C#4.0

VBA

.NET4.5

VS2015

Hi,

I am facing issues like Type Mismatch while passing Array of interfaces from .NET to VBA and vice versa using VSTO technology.

My requirement is that ComInterfaceType needs to be InterfaceIsIDispatch.

My Interface definition is somewhat like this

[ComVisible(true)]
    [InterfaceType(ComInterfaceType.InterfaceIsIDispatch)]
    [Guid("AAF48FBC-52B6-4179-A8D2-944D7FBF264E")]
    public interface IInterface1
    {

        [DispId(0)]
        IInterface2[] GetObj();

        [DispId(1)]
        void SetObj(ref IInterface2[] obj);
    }

    [ComVisible(true)]
    [InterfaceType(ComInterfaceType.InterfaceIsIDispatch)]
    [Guid("CDC06E1D-FE8C-477E-97F1-604B73EF868F")]
    public interface IInterface2
    {     
    }

IF i am passing array of above interface (created in C#.Net) to VBA using GetObj API of IInterface1 from VBA,i am getting type mismatch error in VBA while assigning the value to variable in VBA.Even assigning to variant type variable gives TypeMismatch.


Kindly provide some assistance regarding the same.


Thanks.