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!

Antworten (0)

Kategorien

Produkte

Version

R2013b

Gefragt:

am 15 Apr. 2019

Bearbeitet:

am 26 Apr. 2019

Community Treasure Hunt

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

Start Hunting!

Translated by