A quick copy/paste question

[Peskarik]

Say I have two files in the same directory (say, C:\Data)
File 1 is open, File 2 is closed.

How can I copy say a range of values from sheet 1 of File 1:
ThisWorkbook.Worksheets(1).Range("A1", Range("A1").End(xlDown))

to File 2, Sheet 2, Range (from "B2" down)

without opening File 2?

[Bob Phillips]

Using ADO, but much simpler to open it, copy it, and close it.

[Peskarik]

Using ADO, but much simpler to open it, copy it, and close it.

So basically, that is Macro Recorder way of doing things.

[Bob Phillips]

Not sure what you mean there?

[PhilJette]

as mentioned by XLD the easiest way will be to copy the range, open the file, paste it and close it.
If you want this to happen "Bedind the scenes" you can use:
[VBA]
application.screenupdating = false
application.displayalerts = false
'CODE HERE
application.screenupdating = true
application.displayalerts = true
[/VBA]

[Peskarik]

as mentioned by XLD the easiest way will be to copy the range, open the file, paste it and close it.
If you want this to happen "Bedind the scenes" you can use:
[vba]
application.screenupdating = false
application.displayalerts = false
'CODE HERE
application.screenupdating = true
application.displayalerts = true
[/vba]

I have just read this part in the book.
What I mean by "Recorder way" is copy-open-paste-close.
Anyway, thanks guys!