How do I link to a workbook whose name is variable?

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

Guest

I want to create a link from one workbook to another based upon variable data.

For example,

if the cell A1 contains AAAAA then the link should be to a workbook named
AAAAA.xls
if the cell A1 contains BBBBB then the link should be to a workbook named
BBBBB.xls

Is this possible in Excel 2000?
 
Something like this

=INDIRECT("'" &A1&"Gantt Chart'!$A$7")

with a name style of [Gantt.xls] in the cell, but it will only work with
open workbook.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

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

How to create absolue path link to another workbook (Excel 2003) 1
Linking a cell to another workbook cell based on a variable name 6
Link future workbooks to a summary workbook... 1
Link behavior with changing data set 3
workbook links 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Macro to push data to another workbook 0
Importing named range from another workbook 5

Back
Top