Why does MATLAB hang after using MLPutVar in Excel Link or Spreadsheet Link EX 3.0 (R2007b) ?

In VBA, I create a variable referencing my Excel Worksheet and I use MLPutVar function to export my data to the MATLAB Workspace.

After that, MATLAB hangs and Excel Link does not work anymore. I need to kill the MATLAB process in the task manager.

Answer 1

[MathWorks Support Team]

The MLPUTMATRIX function has to be used when creating or overwriting a matrix in the MATLAB workspace with data from a Microsoft Excel worksheet. The values to be copied are specified by their location in the worksheet either using a worksheet cell address or range name

The function MLPUTVAR is used for exporting Microsoft Excel VBA variable only, such as a double created in VBA.