Running a macro in excel from Matlab

3 views (last 30 days)
David
David on 18 Mar 2016
I have found codes for running macros in excel from matlab, however, it is generic code. Could I see someone's example code for running a macro in excel from matlab. Below is the code I currently have.
xlsfile = 'First_gui.xlsx'; macro = 'Split_Cells';
xls_run_macro(xlsfile,macro);

Answers (1)

Krishna Chaitanya Duggineni
One way to invoke an Excel macro from MATLAB is by launching Excel as a COM server from MATLAB using the 'actxserver' command.
See the example in the link below.
  1 Comment
Guilherme Brigagão
Guilherme Brigagão on 6 Aug 2019
Hey! Can you copy the answer here? I can't see this link..

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!