Thread: How do I set the hyperlink to reference a cell for the file name?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FiluDlidu FiluDlidu is offline
external usenet poster
  
Posts: 66
Default How do I set the hyperlink to reference a cell for the file name?
Here would be an example:
=hyperlink("C:\"&A1&"\FolderX\"&left(B1,3)&"myFile .xls","This is where I can
find "&C1&". Just click the cell")

"Quest41067" wrote:

I am trying to set up a cell with a hyperlink that parts of the path can be
changed by other inputs such as other cells.
Reply With QuoteReply With Quote