Read VBA Module in Excel via ActiveX
2 views (last 30 days)
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?