Copy destination = different file / different Workbook

[artisdepartis]

Hi All,

How can i set a different Workbook as my destination using the code
below or the .Copy Destination = property (Both when my destination
file is open or even when it is closed...)

I now use:

Worksheets(Sheet2).Range("A1:AA" & LastRow).Value = Range("A1:AA" &
LastRow).Value

But get a 'type mismatch' when I use
Workbooks("macro new
created.xls").Worksheets(Sheet2).Range("A1:AA" & LastRow).Value =
Range("A1:AA" & LastRow).Value

I recorded a macro, but want to try to use the above method due to
memory / speed issues.

Any help would be greatly appreciated, as always!

 

[artisdepartis]

To clearify my question: my destination file is open when i run this
macro. (I was just wandering if it needs to be open to work).

 

[Dave Peterson]

The workbooks have to be open.

And if Sheet2 is the name of the worksheet, I think you'll want:

Worksheets("Sheet2").range(....
(with the double quotes)