Excel Link

MLGetVar

Write contents of MATLAB matrix in Excel VBA variable

Syntax

• MLGetVar ML_var_name, VBA_var_name
  
  
  

  ML_var_name	Name of MATLAB matrix to access. "ML_var_name" (in quotes) directly specifies the matrix name. ML_var_name (without quotes) 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.
  VBA_var_name	Name of Excel VBA variable where the function writes the contents of ML_var_name. Use VBA_var_name without quotes.

Description

Writes the contents of MATLAB matrix ML_var_name in the Excel VBA variable VBA_var_name. Creates VBA_var_name if it does not exist. Replaces existing data in VBA_var_name. Use MLGetVar only in a macro subroutine, not in a macro function or in a subroutine called by a function.

Example

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

writes the contents of MATLAB matrix J in the VBA variable named DataJ.

See Also

MLPutVar

MLGetMatrix

MLOpen