The function you'd want to use is =indirect().
But =indirect() won't work if the sending file is closed.
Laurent Longre has an addin (morefunc.xll) at:
http://xcell05.free.fr/
or
http://xcell05.free.fr/morefunc/english/index.htm
That includes =indirect.ext() that may help you.
===
If you have trouble getting to the site, then search google for indirect.ext.
I found this alternative site:
http://download.cnet.com/Morefunc/30...-10423159.html
I didn't look to see if it was the most current version.
I'd check the original site every so often to see if it's working.
marc747 wrote:
Hi,
I have 19 excel files in a folder and I have created another excel
file (B) in which I am trying to set a formula that can look in Cell
"A6" which has the path with the file name of the first file (1) then
copy From the first File (1) cell "L25" an place it in Cell "Y6" of
File (B).
I want the file names or file names with the path to be in file (B) so
that I can change the name easily instead of changing all formulas.
Hope I have clear explanation!
Thanks,
--
Dave Peterson