Guys,

How can I copy lets say sheet1 from excel file named one.xls and paste to a
different excel file named two.xls wherein the sheet name also changes from
sheet1 to Temp? Been try to do this but cannot get it to work.

Earlier in 2003, I got the code via recording a macro but in excel 2007 I am
unable to figure out how to copy sheet using macro.

Thanks.