Automation Matlab_Excel

Hello,
is it possible to create an Excel file via Automation with xlsm extension? If yes, how ?
I am only able to create an xlsx file (cf below).... but I need to execute macro in Excel so xlsm is essential...
Thank you
% clear all
% clc
%% Ouverture d'Excel via Automation (pour intéragir entre matlab et excel)
Excel = actxserver ('Excel.Application');
% Excel.Visible = true ;
%Création et enregistrement d'un classeur
nom_fichier = input('\nName?\n','s');
xlspath = pwd ;
xlsfile = nom_fichier;
Workbook = Excel.Workbooks.Add ;
Workbook.SaveAs(fullfile(xlspath,xlsfile));

Answers (0)

Asked:

on 28 Nov 2018

Edited:

on 28 Nov 2018

Community Treasure Hunt

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

Start Hunting!