MATLAB: Using matlabinit in Excel VBA

excelSpreadsheet Link

Hello. What's the correct syntax for using the matlabinit command in the an Excel VBA script to initialise the Spreadsheet Link EX? I've tried the following. The first one gives me a "Sub or Function not defined" error, while the second doesn't seem to do anything when executed.

sub mat() matlabinit end sub

sub mat() Run matlabinit end sub

Best Answer

Check this:

Working with Spreadsheet and VBA

You just need to add a reference (by clicking a box) to be abl eto use the functions

Related Solutions

MATLAB: How to use Excel Link functions from VBA instead of from an Excel spreadsheet

This example assumes that you have configured Excel to work with Excel Link. If not, please see the Excel Link User's Guide for instructions on how to do so.

In particular, this example requires that:

1. MATLAB has been initialized via "startmatlab" or "matlabinit"

2.Excel Link has been enabled as an Excel Add-In (Tools -> Add-Ins)

3. In Excel VB Editor, Excllink is checked as a reference (Tools -> References).

Option Base 1
Sub Method1()
      MLShowMatlabErrors "yes"
      '''To MATLAB:
      Dim Vone(2, 2) As Double    'Input
      Vone(1, 1) = 1
      Vone(1, 2) = 2
      Vone(2, 1) = 3
      Vone(2, 2) = 4
      MLPutMatrix "a", Range("A1:B2")
      MLPutVar "b", Vone
      MLEvalString ("c = a*b")
      MLEvalString ("d = eig(c)")
      '''From MATLAB:
      Dim Vtwo As Variant         'Output
      MLGetVar "c", Vtwo
      MsgBox "c is" & Vtwo(1, 1)
      MLGetMatrix "b", Range("A7:B8").Address
      MatlabRequest
      MLGetMatrix "c", "Sheet1!A4:B5"
      MatlabRequest
      Sheets("Sheet1").Select
      Range("A10").Select
      MLGetMatrix "d", ActiveCell.Address
      MatlabRequest
End Sub

Also see the related solution concerning how the MLGetMatrix function can handle range objects using their "Address" properties.

MATLAB: Do I receive a “Compile error: Sub or Function not defined” error when calling Excel Link functions from an Excel VBA macro

This error occurs because in Excel VBA, a reference must be set to another application in order to use that application's objects. To set a reference in your VBA project to Excel Link, perform the following steps:

1. Open the Microsoft Visual Basic development environment associated with the version of Excel you are using. Typically, you can browse in Excel by going to the 'Developer' Tab and click on the 'Visual Basic' icon (possibly the first icon on the left). Otherwise, Alt + F11 is another shortcut to open this utility.

2. In the Microsoft Visual Basic development window's project browser, click on your project.

3. From the "Tools" menu, select "References"

4. Check the "Excllink" box and click "OK"

Note: If the "Excllink" box does not appear in the references, make sure that Excel Link is selected as an add-in to Excel.

Best Answer

Related Solutions

MATLAB: How to use Excel Link functions from VBA instead of from an Excel spreadsheet

MATLAB: Do I receive a “Compile error: Sub or Function not defined” error when calling Excel Link functions from an Excel VBA macro

Related Question