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!

Answers (0)

Products

Release

R2013b

Asked:

on 15 Apr 2019

Edited:

on 26 Apr 2019

Community Treasure Hunt

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

Start Hunting!