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?