There may be a few solutions:
http://www.rondebruin.nl/copy7.htm

Or:
http://www.rondebruin.nl/ado.htm

If neither of those options work for you, post back with a little more detail.

HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Varun" wrote:

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.