Receive a Jagged Array in VBA (VB6)

Question

I currently have a VB.NET dll that returns a jagged array of double. This is the declaration:

Public Function CalcMatching(ByRef dataArray1 As Object, 
    ByRef dataLen1 As Integer, ByRef dataArray2 As Object, 
    ByRef dataLen2 As Integer, ByRef matchingType As String) As Double()()

It works well inside VB.NET, but when I insert it into a VBA project, I noticed that after the execution of the funtion, while retrieving the data, the "Type mismatch' excpetion is raised inside VBA.

I searched over the internet, but I could not find a delcaration of a jagged array inside VBA. is that possible? If yes, how can I do it?

Answer 1

Just a guess without seeing the calling VBA code, but I believe this is being caused by having ByRef arguments instead of ByVal. There is stronger type checking when using ByRef arguments which you can read about here.