Need help with file opening formula
 

I'm really needing a formula (or macro) to open a closed file by typin
it's name in a cell.
For example: In cell A1, I type "Filename". In cell B1 I type "F2".
Then C1 will show the contents of file; Filename cell F2
Thank

--
greasybo
-----------------------------------------------------------------------
greasybob's Profile: http://www.excelforum.com/member.php...nfo&userid=792
View this thread: http://www.excelforum.com/showthread.php?threadid=26424

Need help with file opening formula
 

Hi
download morefunc.xll from the following site:
http://longre.free.fr/english
use the formula in C1:
=INDIRECT.EXT("'C:\temp\[" & A1 & ".xls]sheet1'!" & B2)

adapt your path and the sheet reference

--
Regards
Frank Kabel
Frankfurt, Germany

"greasybob" schrieb im
Newsbeitrag ...

I'm really needing a formula (or macro) to open a closed file by
typing
it's name in a cell.
For example: In cell A1, I type "Filename". In cell B1 I type "F2".
Then C1 will show the contents of file; Filename cell F2
Thanks


--
greasybob
---------------------------------------------------------------------
---
greasybob's Profile:
http://www.excelforum.com/member.php...fo&userid=7923
View this thread:
http://www.excelforum.com/showthread...hreadid=264246