supporting 2D arrays in WCF service with excel VBA client RRS feed

  • Question

  • Hello,

    I have create a WCF Service, and an excel VBA client. I want to send a 2D array of strings from VBA to excel. 2D arrays are not supported in WCF, can anyone suggest a solution or an alternative?

    Here is the code


    ReDim Data(nCol, row) As String

    This array is a dynamic array in VBA and values are inserted in this. I want to pass this 2D array in a WCF Service .

    Dim WCFSvcObj As Object
    Set WCFSvcObj = GetObject(WcfServiceAddress)
    WCFSvcObj.SendData(data, Col, row)


    void Senddata(string[,] data, Col, row)
    Monday, March 4, 2013 4:35 AM