MATLAB: How to call a matlab function from an excel macro

call matlabexcel macro

Hi,

I'm creating an excel vba macro. I want to call and open matlab with a specific function by clicking the macro.

Is this possible?

Thanks,

Best Answer

I can do basic things like plot graphs, create variables using this script but as soon as I tell it to run a script it freezes and excel starts giving this message:

'Microsoft Excel is waiting for another programme to complete an OLE Command'

This is the script I used:

    Dim MatLab As Object
  Sub RunMatlabDayfiletool()
   'Create the Matlab Object
    Set MatLab = CreateObject("Matlab.Application")
    Result = MatLab.Execute("cd('\\Directory')")
    Result = MatLab.Execute("x = -pi:.1:pi; y = sin(x); plot(x,y)")
  End Sub

Related Solutions

MATLAB: How to create a small macro in Excel that gets data from MATLAB via ActiveX

In order to create a small macro in Excel that gets called from MATLAB via ActiveX control, please follow the steps mentioned below:

1. Start Excel.

2. Go to the Tools menu of Excel and select Macro-->Macros. A dialog box will appear.

3. Enter Example1 in the Macro Name box, and click on Create. A Visual Basic editor will appear.

You are now ready to enter your macro. The following is an example of a macro that produces a mesh grid in MATLAB and returns the peaks matrix. The first and last lines of the macro should already appear in the sheet Module1.

'===============================================
' Example1 Macro
' Macro recorded 02/21/95 by The MathWorks, Inc.
'===============================================
' Declare a Matlab variable here so it stays open
' when Sub Example1 goes out of scope
Dim MatLab As Object
Sub Example1()
        'Create the Matlab Object
      Set MatLab = CreateObject("Matlab.Application")
      'Execute MATLAB commands
      Result = MatLab.Execute("h=peaks(10);colormap(pink);mesh(h);drawnow")
      'Get some matrix from MATLAB
      Dim MReal(9, 9) As Double
      Dim MImag() As Double
      Dim RealValue As Double
      Dim i, j As Integer
      'Result = MatLab.Execute("a = [1 2 3 4; 5 6 7 8;]")
      Call MatLab.GetFullMatrix("h", "base", MReal, MImag)
      'Make sheet1 active.  This selects the target sheet.
      'Commenting out this line means that the sheet
      'operated on is the current sheet.
      Sheets("sheet1").Select
      'Put in a string
      Range("B10:B10").Value = "The content of variable h"
      'Fill Excel sheet cells with data from MATLAB
      Range("B11:K20").Value = MReal

End Sub

Once this macro is complete, save it and close out of the Visual Basic Editor. You can run the macro by opening the macros dialog box in Excel, selecting Example1, and clicking on Run.

You can also download an example macro that has already been set up by clicking on the file below.

MATLAB: Is it possible to call MATLAB files from a Visual Basic application using ActiveX

It is possible to call MATLAB files from a Visual Basic application using ActiveX features.

Here is an example:

Dim MatLab As Object
Private Sub Command1_Click()
Dim Result As String 
Dim MReal(1, 3) As Double 
Dim MImag() As Double
Set MatLab = CreateObject("Matlab.Application")
'CALLING MATLAB FILE FROM VB
Result = MatLab.Execute("cd D:\MATLABR12\work\alltest") 
Result = MatLab.Execute("myfile") 
'OTHER THINGS THAT CAN BE DONE
Result = MatLab.Execute("surf(peaks)") 
Result = MatLab.Execute("a = [1 2 3 4; 5 6 7 8;]") 
Result = MatLab.Execute("b = a + a ")
Call MatLab.GetFullMatrix("b", "base", MReal, MImag)
End Sub

For more information, refer to Chapter 7 of the MATLAB External Interface/API User's Guide.

Best Answer

Related Solutions

MATLAB: How to create a small macro in Excel that gets data from MATLAB via ActiveX

MATLAB: Is it possible to call MATLAB files from a Visual Basic application using ActiveX

Related Question