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

조회 수: 3 (최근 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
Lutz Thieschäfer 2018년 3월 7일

카테고리

Help CenterFile Exchange에서 ActiveX에 대해 자세히 알아보기

제품

Community Treasure Hunt

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

Start Hunting!

Translated by