Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for having next number show when opening file | Excel Discussion (Misc queries) | |||
Opening file in Excel 2003 opens multipule instances of same file | Excel Discussion (Misc queries) | |||
File:1 and File:2 -- Double Files when Opening One File | Excel Discussion (Misc queries) | |||
opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
Formula related Crash on Opening File | Excel Worksheet Functions |