| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel - How to indirectly access a file whose name is in a cell
With text in A1: My-Junk.xls, text in A2: Sheet1, text in A3: A1
Formula in A4: =INDIRECT(CHAR(39)&"["&A1&"]"&B1&CHAR(39)&"!"&C1) I can pick up the content of the cell in the other file. Many thanks to Bob Umlas for showing where I was going wrong. -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "DaveAlbany" wrote in message ... In workbook A, I want to have a cell filled with the name of a second .xls file (which may change) and then access cells in workbook B from the original workbook A. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| excel cell lookup file on harddrive | Excel Discussion (Misc queries) | |||
| Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
| Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
