Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linked File Names and Path
Suppose I have a file that is linked to multiple different Workbooks.
Suppose that Cell A1 on Sheet1 is linked to a particular workbook such as: =+[SourceExample.xls]TestSheet$a$1 What I need to be able to do is get the full file name and path of the SourceExample.xls sheet in this case. I was previously capturing the file location in the source file and passing it to the destination file, via a linked cell, however that requires the user to update (on open and save) the source file everytime the file is moved. Thanks in advance for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Relative vs. Absolute Path Names for linked cell data | Excel Discussion (Misc queries) | |||
Image File Path for Linked Pictures | Excel Programming | |||
Linked file in same folder but unknown path | Excel Programming | |||
Indirect and Path & File Names | Excel Discussion (Misc queries) | |||
Copy and Paste Formula Without the linked file path | Excel Worksheet Functions |