MATLAB Answers

Read VBA Module in Excel via ActiveX

1 view (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?


Sign in to comment.

Answers (0)