Solved: copy paste doesn't work

[shrivallabha]

Just curious. Why do you want to create another instance of Excel? You can certainly use:
[VBA]Application.Workbooks.Open ("C:\Users\vdaga7c\Desktop\test2.xls")[/VBA]
And then explicit workbooks names before like:
[VBA]Workbooks("test2").Sheets("sheet1").Range("A1").copy Destination:= Workbooks("test1").Sheets("sheet1").Range("B2")
[/VBA]