using cell references within file names in links

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a link in a cell (e.g. "[filename.xls]worksheet1'!$J$13"). I want
the filename.xls portion of the link to be from a cell (e.g., A1) rather than
to be hardcoded. I have tried a few ways to do this, unsuccessfully. Any
thoughts? Thanks.
 
One way is to use the Indirect function (refer built-in help).
But beware ... the file that you're referencing has to be open, or
the function returns a Ref# error.
Rgds,
ScottO

| I am using a link in a cell (e.g.
"[filename.xls]worksheet1'!$J$13"). I want
| the filename.xls portion of the link to be from a cell (e.g., A1)
rather than
| to be hardcoded. I have tried a few ways to do this,
unsuccessfully. Any
| thoughts? Thanks.
 
Hi,

I have the same problem. Did you got another response to your question ?
 
You must log in or register to reply here.

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

reference to an external file 6
making a portion of reference to a worksheet variable in a formula 1
Indirect concatenated link doesn't work with UNC 9
Inserting rows in link source - doesn't show up in link destination? 5
File Location Based on Cell Reference 4
How to refresh all Cells in an Excel Workbook automatically? 1
Named Ranges -- Link Issue? 2
Cell Referencing In Header 3

Back
Top