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

C

Carl Borthwick

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?
 
B

Bob Phillips

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)
 
Top