Excel Link

Macros

• To create macros that use Excel Link functions, you must first configure Excel to reference the functions from the Excel Link add-in. From the Visual Basic environment pull down the Insert menu and select Module. When the Module page opens, pull down the Tools menu and select References.... In the References window, select the box for excllink.xla and click OK. You may have to use Browse to find the excllink.xla file.
• If you use MLGetMatrix in a macro subroutine, enter MatlabRequest on the line after MLGetMatrix. MatlabRequest initializes internal Excel Link variables and enables MLGetMatrix to function in a subroutine. For example:

• Sub Get_RangeA()
  MLGetMatrix "A", "RangeA"
  MatlabRequest
  End Sub
  

• Do not include MatlabRequest in a macro function unless the macro function is called from a subroutine.

Worksheets

Data Types