Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a non-specific file link
Is there a way to link two separate workbooks files using only the current
folder they reside in? When I create a cell link between the two files I get the following: ='C:\data\TESTING\test1\[seat #1.xls]Sheet1'!$C$11 I'm trying to create a generic template file that will use data from files called seat #1.xls seat #2.xls seat #3.xls So I'm trying to link the cells only using files in the same folder that would not be as specific as C:\data\TESTING\test1\. I figure I could write a macro that would ask for the location of seat #1.xls, etc, but I was hoping there is a simplier method. Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a copy in the same folder when a file is modified and saved | Excel Discussion (Misc queries) | |||
Excel updating from XML file - file path specific? | Excel Discussion (Misc queries) | |||
Unable to create any link/hyperlinks in a particular excel file | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel |