Effacer les filtres
Effacer les filtres

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

6 vues (au cours des 30 derniers jours)
Lutz Thieschäfer
Lutz Thieschäfer le 20 Déc 2017
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...

Réponses (1)

Lutz Thieschäfer
Lutz Thieschäfer le 7 Mar 2018

Produits

Community Treasure Hunt

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

Start Hunting!

Translated by