Search All of the Math Forum:
Views expressed in these public forums are not endorsed by
Drexel University or The Math Forum.
|
|
|
|
Re: Copy a formatted sheet in Excel
Posted:
Sep 11, 2009 6:30 AM
|
|
I am trying to follow the advice given, but I think I have a syntax problem:
I coded the following, using the examples given, and looking at a recorded macro that I made copying one sheet:
excel = actxserver('excel.application');
% open the excel file, full path need to be mentioned or else excel will pick it from most recently opened files.
wkbk = excel.Workbooks.Open([pwd '\' DestFile]);
wksheet = wkbk.Worksheets.Item('Form1'); % Choose desired sheet
co=wksheet.Copy After:=Sheets(4);
wkbk.Save % save the changes
excel.Quit % close excel
but of course the "After:=Sheets(4)"
does not work, it is matlab syntax error: I get
Unexpected MATLAB expression.
If I code only
co=wksheet.Copy
I get:
??? One or more output arguments not assigned during call to "Copy".
How do I specify the argument "After" that says after which sheet I have to copy? there is here probably some special syntax that I am missing.
Any help will be very appreciated!
Best regards
Claudio
|
|
|
|
