| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I am trying to refer to a cell to open an external link
Here is my problem. I want to access external file(s) based on a name in a cell
A1 Example1 A2 =C:\Test\"A1".xls!$a$3 As the above formula stands I want it to open a file with the following C:\Test\Example1.xls$a$3 If A1 where changed to Example2 then the following would open C:\Test\Example2.xls$a$3 In short I want the path and file name changeable based on a cell reference. Thanks in advance for any help you can give me. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating link to external source without having it open | Excel Discussion (Misc queries) | |||
| link to a cell in an external spreedsheet | Excel Worksheet Functions | |||
| Cell External Link in a sheet | Excel Discussion (Misc queries) | |||
| GetPivotData refer to external cell | Excel Worksheet Functions | |||
| External link only works for numbers -- for text values, #N/A is displayed unless linked file is open | Links and Linking in Excel | |||
Threaded Mode
