Read VBA Module in Excel via ActiveX

I run ML 2019a. I know how to connect with the Excel COM server. I know how to read and write material from and into an Excel speadsheet from Matlab. I also know how to call an Excel VBA macro from Matlab and how to create and write a VBA module from Matlab. What I haven't been able to figure out is this: Can I retieve a list of the existing VBA modules of an Excel file from Matlab and read their content?

回答 (0 件)

タグ

質問済み:

2019 年 8 月 26 日

編集済み:

2019 年 8 月 26 日

Community Treasure Hunt

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

Start Hunting!

Translated by