Prev: Euler's Method Matlab Code: initial value problem
Next: Binary Trouble.
From: Marco on 26 Apr 2010 04:06
Hi,

i need to copy a chart from an excel file to another using matlab. I need to copy the whole sheet. I've try to read the Visualbasic script that do this operation, but i've not fullfilled my task.

After i've the actxserver for use excel:
Excel = actxserver ('Excel.Application');
Workbook=invoke(Excel.Workbooks,'Open',file_name);
I try this command:
invoke(Charts,'Copy');

it made a copy of what i need, but he copy this file to a new woorkbook and save it in the default directory.

The command to do what i want in visual basic is this:
Sub copia_grafico()

Sheets("Graphic").Select
Sheets("Graphic").Copy After:=Workbooks("20100420_RIASSUNTO.xls").Sheets(2)
End Sub

So i think that i the only thing i need is to know how to give to matlab the visualbasic command "After:=Workbooks("20100420_RIASSUNTO.xls").Sheets(2)".

can someone help me?
 | 
Pages: 1
Prev: Euler's Method Matlab Code: initial value problem
Next: Binary Trouble.