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

2 views (last 30 days)
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.

Accepted Answer

MathWorks Support Team
MathWorks Support Team on 30 Jul 2009
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.

More Answers (0)

Categories

Find more on Data Export to MATLAB in Help Center and File Exchange

Products


Release

R2007b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!