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

7 次查看（过去 30 天）
Lutz Thieschäfer
Lutz Thieschäfer 2017-12-20
回答： Lutz Thieschäfer 2018-3-7
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...

请先登录，再回答此问题。

回答（1 个）

Lutz Thieschäfer

类别

在 Help Center 和 File Exchange 中查找有关 ActiveX 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by