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