Reference workbook cell to another workbook

[farrukh]

HI All,

I need a vba code that get reference from defined range (cells) to another workbook.
Suppose i have two workbook in a specific folder C:\temp\ (workbook1.xlsx,workbook2.xlsx). I want that workbook2.xlsx get reference from workbook1.xlsx.

Thanks
farrukh

[Bob Phillips]

Open both workbooks. Reference from one top the other, then close the second.