Products & Services Solutions Academia Support User Community Company

Learn more about Spreadsheet Link EX   

MLGetVar - Write contents of MATLAB matrix in Microsoft Excel VBA variable

Syntax

MLGetVar ML_var_name, VBA_var_name 

ML_var_name

Name of MATLAB matrix to access. "ML_var_name" (in quotation marks) directly specifies the matrix name. ML_var_name (without quotation marks) is an indirect reference: the function evaluates the contents of ML_var_name to get the matrix name, and ML_var_name must be a VBA variable containing the matrix name as a string. var_name cannot be the MATLAB variable ans. If defined, ML_var_name should be of type VARIANT. Any other type will give a "TYPE MISMATCH" error.

VBA_var_name

Name of VBA variable where the function writes the contents of ML_var_name. Use VBA_var_name without quotation marks.

Description

Writes the contents of MATLAB matrix ML_var_name in the Excel Visual Basic for Applications (VBA) variable VBA_var_name. Creates VBA_var_name if it does not exist. Replaces existing data in VBA_var_name.

Examples

Write the contents of the MATLAB matrix J into the VBA variable DataJ:

Sub Fetch()
MLGetVar "J", DataJ
End Sub

See Also

MLPutVar

  


Recommended Products

Includes the most popular MATLAB recorded presentations with Q&A sessions led by MATLAB experts.

 © 1984-2009- The MathWorks, Inc.    -   Site Help   -   Patents   -   Trademarks   -   Privacy Policy   -   Preventing Piracy   -   RSS