| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calling a value from another file using a variable in the file nam
The formula works OK for me, but if there are single quotes in the workbook
name (e.g. "december's.xls"), they'll have to be doubled. This modification should work for all workbook names. =INDIRECT(CONCATENATE("'[daily flash ",SUBSTITUTE(E3,"'","''"),".xls]sheet1'! E22")) Otherwise, you can troubleshoot it by selecting the concatenate part of the formula in the formula bar, press F9, copy, (ESC to revert formula), paste result into cell, and go from there. -- Tim Zych SF, CA "DA_Potts" wrote in message ... I want to be able to get a vale from another Excel file where the value of "E3" will change depending on the day of the month. Below was what I tried, but it did not work. =INDIRECT(CONCATENATE("'[daily flash ",E3,".xls]sheet1'! E22")) I have the file open that Iwant to call from. I am using Excel 2003. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calling a value from another file using a variable in the file nam | Excel Discussion (Misc queries) | |||
| Calling a specific worksheet from a hyperlink in a seperate file. | Excel Worksheet Functions | |||
| Calling a common XLA Library file, stored on a network drive :) | Excel Discussion (Misc queries) | |||
| Calling a common XLA Library file, stored on a network drive :) | Setting up and Configuration of Excel | |||
| When calling a different file, can I make the tab equal to a cell? | Excel Discussion (Misc queries) | |||
Hybrid Mode
