Hi,
I need help in copying two worksheets in different workbooks into on
workbook with two sheets .

Example
report1.xls has one sheet name report1
report(1) .xls has one sheet name report1(1)

i want to move this two into one workbook
name newexcel.xls with two sheets name report1 and report1(1)

Can anyone help me in writing the code ...

Thanks
Punith

--
ps
-----------------------------------------------------------------------
psk's Profile: http://www.excelforum.com/member.php...fo&userid=1573
View this thread: http://www.excelforum.com/showthread.php?threadid=27773