software

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(quot;'quot; amp;A1amp;quot;Gantt Chart'!$A$7quot;)

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)

quot;Carl Borthwickquot; lt;Carl gt; wrote in message
...
gt; I want to create a link from one workbook to another based upon variable
data.
gt;
gt; For example,
gt;
gt; if the cell A1 contains AAAAA then the link should be to a workbook named
gt; AAAAA.xls
gt; if the cell A1 contains BBBBB then the link should be to a workbook named
gt; BBBBB.xls
gt;
gt; Is this possible in Excel 2000?