How to run excel macro via MATLAB on another pc
조회 수: 5 (최근 30일)
이전 댓글 표시
I would like to run different excel macros on different computers via MATLAB on the main computer, then gathering all those data.
댓글 수: 0
채택된 답변
Vijay
2022년 11월 17일
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:
Link 2:
Hope that helps!
댓글 수: 0
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File 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!