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?