Read VBA Module in Excel via ActiveX

2 views (last 30 days)
Yvan Lengwiler
Yvan Lengwiler on 26 Aug 2019
Edited: Yvan Lengwiler on 26 Aug 2019
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?

Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!