I am using VB for Excel. I want to copy from a file and paste in another file.
I open the first file and write

Sheet.application.worksheets("Sheet1").range("A1:E1").select
Sheet.application.worksheets("Sheet1").range("A1:E1").copy

Then I open the second file (closing or not the first file does not make a difference) and write

Sheet.application.worksheets("Sheet1").range("A1:E1").select
Sheet.application.worksheets("Sheet1").range("A1:E1").paste

It gives me ERROR at the last line, it does not accept "paste". I tried all possible changes. Any help?