Read VBA Module in Excel via ActiveX

3 visualizaciones (últimos 30 días)
Yvan Lengwiler
Yvan Lengwiler el 26 de Ag. de 2019
Editada: Yvan Lengwiler el 26 de Ag. de 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?

Respuestas (0)

Categorías

Más información sobre Use COM Objects in MATLAB en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by