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

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?

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

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)

"Carl Borthwick" <Carl wrote in message
...
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?