Excel Link

MLPutVar

Create or overwrite MATLAB matrix with data from Excel VBA variable

Syntax

• MLPutVar ML_var_name, VBA_var_name
  
  
  

  ML_var_name	Name of MATLAB matrix to create or overwrite. "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 whose contents are written to ML_var_name. Use VBA_var_name without quotes.

Description

Creates or overwrites matrix ML_var_name in MATLAB workspace with data in VBA_var_name. Creates ML_var_name if it does not exist. If ML_var_name already exists, this function replaces the contents with data from VBA_var_name. VBA_var_name can contain either numeric data or string data but not both. Use MLPutVar only in a macro subroutine, not in a macro function or in a subroutine called by a function.

Example

• Sub Put()
  MLPutVar "K", DataK
  End Sub
  

creates or overwrites MATLAB matrix K with the data in the VBA variable DataK.

See Also

MLGetVar

MLPutMatrix

Error Messages and Troubleshooting