I have two excel files:
file1.xlsx has a formatted sheet that I want to copy and paste into sheet 2 of a new workbook: file2.xlsx.
Basically I want to copy a sheet from one book to another.
This is what I have so far( I have tried to modify what I've found from other Threads)
Excel = actxserver('excel.application');
wkbk = Excel.Workbooks.Open('file1');
wksheet = wkbk.Worksheets.Item('Sheet1');
wkbk = Excel.Workbooks.Open('file2.xlsx');