Running Matlab script from Excel

I have a Matlab m-file that I would like to execute from Excel. How do I write the Excel VBA code to do so?

I have Spreadsheet Link EX installed and I am able to import and export values between Excel and Matlab, but I can't seem to find an easy way to run my custom m file.

Answer 1

[Chirag Gupta]

With the spreadsheet Link EX installed, you should be call your custom MATLAB code using the Add-in.

Click on MATLAB Add-in -> Run custom code -> Enter your function name

For doing so in VBA, refer to

MLEvalString

[Dhana Raj]

Thanks. Tried this earlier, but it didn't seem to work. Works now after I fiddled around with the file paths where my script was located.

Answer 2

[Kaustubha Govind]

See Examples of a MATLAB Automation Server

[Chirag Gupta]

This will not utilize the already running Spreadsheet link

[Dhana Raj]

Thanks for the suggestion.