Posted to microsoft.public.excel.programming
|
|
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.
.
|