How to call a matlab function from an excel macro

Question

Aadil 2012-8-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/46065-how-to-call-a-matlab-function-from-an-excel-macro

评论： Harini Indla 2019-11-27

采纳的回答： Aadil

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,

3 个评论
显示 1更早的评论隐藏 1更早的评论

Aadil 2012-8-16

在 MATLAB Online 中打开

    Dim MatLab As Object
  Sub RunMatlabDayfiletool()
   'Create the Matlab Object
    Set MatLab = CreateObject("Matlab.Application")
    Call MatLab.Execute("cd('D:\OLD')")
    Call MatLab.Execute("AutoMakeFile.m")
  End Sub

I ran this is vba, matlab opens up but doesn't run the script. When typing in 'cd' the path shown is the correct one

Can someone help with this?

Thanks

Harini Indla 2019-11-27

When I saw the example for this type of scripts in https://in.mathworks.com/help/matlab/ref/execute.html?searchHighlight=MatLab.Execute&s_tid=doc_srchtitle site I have observed that

Set Matlab = CreateObject("matlab.application")

but in your script it is different and try using "Feval" functionfor calling something in it.

for example check more about feval

https://in.mathworks.com/help/matlab/ref/com.feval.html

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Aadil 2012-8-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/46065-how-to-call-a-matlab-function-from-an-excel-macro#answer_56766

在 MATLAB Online 中打开

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