Run VBA code in MS Office through COM

3 views (last 30 days)
Sergey Kasyanov
Sergey Kasyanov on 15 Apr 2019
Edited: Sergey Kasyanov on 26 Apr 2019
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

Community Treasure Hunt

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

Start Hunting!