Running a macro in excel from Matlab
2 views (last 30 days)
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);
0 Comments
Answers (1)
Krishna Chaitanya Duggineni
on 23 Mar 2016
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
See Also
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!