MLGetMatrix does not return something into xls although flag says "command sucessful"

Question

0 个投票

I am trying to use MLGetMatrix from the Spreadsheet Link EX toolbox. I can see the out variable in the workspace but it does not return somehing into xls although the test flag is set to 0 indicating that the command succeeded:

Sub testmlxls()

    MLEvalString "clear all"
    MLShowMatlabErrors "yes"
    MLPutMatrix "in", Range("B1")
    MLPutMatrix "in2", Range("B2")
    MLEvalString ("out = in + in2")
     test = MLGetMatrix("out", "test!B3")  ‘Cells(3, 2).Address
End Sub