How to run excel macro via MATLAB on another pc

I would like to run different excel macros on different computers via MATLAB on the main computer, then gathering all those data.

Answer 1

[Vijay]

Hello @Mohammad Azadi Tabar

Link 1 demonstrates how you can do it on a local machine.

In order to do it on a remote computer you need to modify the call to ‘actxserver’ function and make some changes in setting in your master machine as well as slave machines.

The changes that need to be done are given in Link 2.

The modifies call is

%code

ExcelApp = actxserver('Excel.Application',’ip_of_slave’);

Link 1:

How can I run an Excel macro from MATLAB? - MATLAB Answers - MATLAB Central (mathworks.com)

Link 2:

How can I utilize MATLAB on a remote machine as a Distributed COM (DCOM) server? - MATLAB Answers - MATLAB Central (mathworks.com)

Hope that helps!