Create a non-specific file link

S

Seth

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a dynamic master file 1
Link Cell to cell in different file 1
Outlook 2010 can't find .pst file 1
Synchronization problems while moving folders to new email 1
Broken Excel Links - move files to another computer 0
Nested if issue 1
How to Import data from a different .xls file 2
I'm caught in a loop - Require specific cell entry before saving file 0

Top