How to run excel macro via MATLAB on another pc

4 次查看(过去 30 天)
I would like to run different excel macros on different computers via MATLAB on the main computer, then gathering all those data.

采纳的回答

Vijay
Vijay 2022-11-17
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:
Link 2:
Hope that helps!

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Use COM Objects in MATLAB 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by