Copying data across 2 xcel files

[Gandei]

Hi there

I have 2 separate xcel files and want to copy columns A
of file1 into A of file2.
To copy across different sheets in the same file I would do
Sheet1.Range("A").Value = Sheet2.Range("A").Value

Is there a way to copy across 2 different xcel files in a
simliar manner show above, so that I would avoid the use
of clip board.
Currently I'm copying them using clip board as shown below:

Workbooks("File1.xls").Activate
Range("A").Select
Selection.Copy
Workbooks("File2.xls").Activate
Range("A").PasteSpecial
Application.CutCopyMode = False 'Clears wriggly worms


Thanks
Gandei

 

[Tom Ogilvy]

workbooks("File2.xls").Sheet1.Range("A").Value = _
Workbooks("File1.xls").Sheet2.Range("A").Value