Run VBA code in MS Office through COM

Hello,
I need to take some data from program through COM but that program does not working with Matlab correctly. However that program works with Excel through COM.
I know that I can take access to Excel by the command Excel=actxserver('Excel.Application') but I can't find a manual for working with it.
So I have some questions:
1) where i can find information about working with Excel through COM?
2) how i can run VBA scripts in Excel through Matlab and get access to result?
Thanks!

Réponses (0)

Catégories

Produits

Version

R2013b

Community Treasure Hunt

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

Start Hunting!

Translated by