Can Matlab write a macro in an Excel file via ActiveX?

7 visualizaciones (últimos 30 días)
Lutz Thieschäfer
Lutz Thieschäfer el 20 de Dic. de 2017
Respondida: Lutz Thieschäfer el 7 de Mzo. de 2018
There are several posts and instructions how to run Excel macros with Matlab via ActiveX. But is it possible to write such a macro with Matlab into an Excel file?
Background: I wrote a Matlab tool which exports data into Excel files. These Excel files should have a specific macro included which is dependend on the containing data.
Well there is an ugly workaround: I can create Excel templates with the specific macro already included. Then the respective template is copied and filled with the export data. But maybe there is a better and more flexible solution to this problem...

Respuestas (1)

Lutz Thieschäfer
Lutz Thieschäfer el 7 de Mzo. de 2018

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by