Thread
:
How do I link to a workbook whose name is variable?
View Single Post
#
2
Posted to microsoft.public.excel.misc
Bob Phillips
Posts: n/a
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?
Reply With Quote