VBA

[QWERTY]

I have three files opened in Excel and I would like to retrive info from two of them and put it in the third one. I know how to do with just two files, but with three of them I'm confused. How can I write a code so computer knows that now I want cell (1,1) from FirstFile.xls and (2,2) from SecondFile.xls to put it in cells (4,4) and (5,5) respectively in ThirdFile.xls (I know that last part). All of those files are opened using WorkBooks.Open Method
Thanks for your help


------------------
Visual Basic Programmer (at least I want to be one)
------------------
PolComSoft
You will hear a lot about it.

[Lyla]

Try this quick one:

- first activate the current sheet.
- Cell(4,4) would be:
Activesheet.cell("D4").value= sheet1.cell("A1").value

and so on.

Good Luck