Thread: Referencing Cell Info to call a File
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
stuckupnorth stuckupnorth is offline
external usenet poster
  
Posts: 1
Default Referencing Cell Info to call a File

I can't get it to work. What I am trying to do is - Change the workbook
name I am refering to by calling the filename from a cell. Can I put
INDIRECT inside the [ ] of a workbook identifier?

='[K20060707.XLS]1 - General Statistics'!$C$12 - This Works

How do I change the formula so that the workbook information -
"K20060707.XLS" is called from a cell on another worksheet.


--
stuckupnorth
------------------------------------------------------------------------
stuckupnorth's Profile: http://www.excelforum.com/member.php...o&userid=31330
View this thread: http://www.excelforum.com/showthread...hreadid=559261

Reply With QuoteReply With Quote