reference cells in 2 sep files
 

John,

Use something like

Worksheets("Sheet1").Cells(i,j).Value = _
Workbooks("Book2.xls").Worksheets("Sheet2").Cells( i,j).Value


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com



"John" wrote in message
...
Hi all,

i wish to popolate cell(i,j) in one Excel File with values
from a sheet inanother Excel File.
e.g.
sheets("Sheet1").cells(i,j) = Sheets("Sheet2").cells(i,j)

but how do i refer to cells in a different file altogether?
i've tried this (but it doesn't work!)

Sheets("Sheet1).cells(i,j) = Windows("FileA.xls").Sheets
("Sheet1").cells(i,j)

TIA,
John.

reference cells in 2 sep files
 

Thanks Chip,

that's worked a treat!

john.
-----Original Message-----
John,

Use something like

Worksheets("Sheet1").Cells(i,j).Value = _
Workbooks("Book2.xls").Worksheets("Sheet2").Cells
(i,j).Value


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com



"John" wrote in message
...
Hi all,

i wish to popolate cell(i,j) in one Excel File with
values
from a sheet inanother Excel File.
e.g.
sheets("Sheet1").cells(i,j) = Sheets("Sheet2").cells
(i,j)

but how do i refer to cells in a different file
altogether?
i've tried this (but it doesn't work!)

Sheets("Sheet1).cells(i,j) = Windows("FileA.xls").Sheets
("Sheet1").cells(i,j)

TIA,
John.


.