vba code for setting the cell value to be equal to cell value in another workbook

[yellowpower]

e.g. I want Cells(1,1) to be equal to [anotherworkbook.xls]anotherworksheet'!Cells(1,1)
How should I write the code.

Thanks guys

[johncassell]

This seems to work good even when the other workbook is closed

Please Login or Register  to view this content.

[snb]

='E:\[address.xls]Sheet1'!A1

[yellowpower]

Hey experts,
I need to a macro/vba that replicate the action the pressing the downarrow key.
So that when my spreadsheet is grouped/ungrouped, when e downarrow key is pressed, it may select a different cells.
e.g. when row 8 to 10 is grouped, current active cell at cells(7,1), when pressing downarrow, it will select cells(10,1).
thanks!