Running a macro in excel from Matlab
Show older comments
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
on 23 Mar 2016
0 votes
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
on 6 Aug 2019
Hey! Can you copy the answer here? I can't see this link..
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!