Prev: Scripting CATIA V5 from Matlab via COM interface
Next: how to plot cdf as scatter plot
From: Carole BAROME on 9 Mar 2010 12:21
Hi,
I am trying to use an external application from Matlbab, it's a .xla macro that I can use in Excel.
Here's my code :

actx_excel = actxserver('Excel.Application');
actx_excel.Visible = 1;
Workbooks = actx_excel.Workbooks;
Workbook = Workbooks.Open(nomfichier);
current_feuille = actx_excel.Worksheets.Item(1);
current_feuille.Activate;
xlstats = actx_excel.AddIns.Add('macro.xla',1)
actx_excel.AddIns.Item(10).Installed = 1;
result= actx_excel.ExecuteExcel4Macro('!MACRO()','Aide');

This code does not work, I have in the command window :
result = ActiveX VT_ERROR:
And the help menu of my macro has not been run.

Please, could someone help me use this macro?
Moreover, for the second step, I'd like to pass data to this macro as arguments, excel range for example.
Thanks in advance.
 | 
Pages: 1
Prev: Scripting CATIA V5 from Matlab via COM interface
Next: how to plot cdf as scatter plot