How to open matlab by using VBA

Question

please help me to solve this problem.

The problem is how to open matlab from VB excel. I have used code "matlabinit". but when I run it in VB excel, I can open matlab application, but the opened current directory did not like what I want. I want open matlab from VB excel with the specific currect directory as I want.

Thanks for your answer.

Dan · Accepted Answer · 2012-08-15 12:52:13Z

1

Easiest way to do it is to call matlab function to change the current folder. This way it will be specific to your project at hand. So put this line at the start of where you start to interact with matlab:

MLEvalString "cd('C:\MyFolder')"

answered Aug 15, 2012 at 12:52

Dan

45.8k20 gold badges98 silver badges169 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Febri Dwi Laksono Over a year ago

thanks you Mr. Mr.Dan Can you help me to solve my problem in this link? stackoverflow.com/questions/11965330/how-to-make-faster-looping

Dan Over a year ago

No, that question is incomprehensible.

Community · Accepted Answer · 2017-05-23 10:24:39Z

0

You can find a description of how to do so here.

You use shell in VBA to run Matlab, roughly like this:

in VBA

shell "C:\Matlab2011a\matlab.exe -r your_function_name

and in your Matlab code

function yourFunction()
  cd('C:\yourDirectory');  % moves you to your desired directory
                           % your code here
  exit;                    % exits Matlab
end

Alternatively you can manage your directory in VB itself by using the method found on this previous post

edited May 23, 2017 at 10:24

CommunityBot

11 silver badge

answered Aug 15, 2012 at 12:39

Salain

7926 silver badges15 bronze badges

Collectives™ on Stack Overflow

How to open matlab by using VBA

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related