| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving worksheet in new file with date AND cell value as file name | Excel Discussion (Misc queries) | |||
| Cell Limitations ? Formatting and Size when exporting to Tab based Text file? | Excel Worksheet Functions | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| How do I use a cell as a referance to a file in a lookup statemen. | Excel Worksheet Functions | |||
| Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) | |||
Threaded Mode
