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));

Antworten (0)

Gefragt:

am 28 Nov. 2018

Bearbeitet:

am 28 Nov. 2018

Community Treasure Hunt

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

Start Hunting!

Translated by