Get Value from a cell

[michaelm702]

I need to Get Value from a cell in other spreadsheet which is closed and the path to the spreadsheet & cell will be provided as input and the value from the cell should be returned. Is there any way or macro to do it.

[Bob Phillips]

Try the INDIRECT.EXT function in Laurent Longre's
MOREFUNC.XLL add-in, available from

http://xcell05.free.fr/english/ (http://xcell05.free.fr/english/)