Passing Array from C#/.NET back to VBA

[Jay Martin]

Hi,

I'm trying to send an Array (of ushort[] ) values to be used in VBA.

My C# is returning a Array object 

public static object HORDoAcquisition(bool shutterOpen)
        {
            if (_currentDev == null)
                return null;
            var data = _currentDev.AcquireOneSpectra(shutterOpen);
            return data;
        }

My VBA code is as follows

Function GetData() As Object

Dim data As Object
Set data = Application.Run(cmdDoAcquisition, True)

GetData = data

End Function

"data" above doesn't appear to receive the 1d array of ushort values..

Any help / direction is greatly appreciated.

[Govert van Drimmelen]

Hi Martin,

That ushort[] array data type is not supported by Excel-DNA.

I suggest you convert to a double[] before returning.

-Govert