PDA

View Full Version : Reference workbook cell to another workbook



farrukh
08-25-2011, 01:08 PM
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
08-25-2011, 01:41 PM
Open both workbooks. Reference from one top the other, then close the second.