Thread: Q: Can a formula reference a cell to get the file name to link to for data?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
mgarcia
 
Posts: n/a
Default Q: Can a formula reference a cell to get the file name to link to for data?

I could not seem to get that to work correctly. It seems whatever I put
in as a reference for the file name ('FILENAME.XLS'! - tried
INDIRECT(A1)!) just would not work. The formula thinks the reference
is the file name it's looking for. I may have miss understood that
function as well....


--
mgarcia
------------------------------------------------------------------------
mgarcia's Profile: http://www.excelforum.com/member.php...o&userid=30584
View this thread: http://www.excelforum.com/showthread...hreadid=502342

Reply With QuoteReply With Quote