MATLAB Answers

Run VBA code in MS Office through COM

4 ビュー (過去 30 日間)
Sergey Kasyanov
Sergey Kasyanov 2019 年 4 月 15 日
編集済み: Sergey Kasyanov 2019 年 4 月 26 日
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?

  0 件のコメント


回答 (0 件)





Community Treasure Hunt

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

Start Hunting!

Translated by