MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Combining Cells to create filename link


Posted by Andy on March 15, 2001 3:22 PM

How can I create a link in a workbook that combines information from cells (filename, sheetname, cell location etc) in that workbook that point to another workbook that is closed. The INDIRECT function goes some of the way to doing this but will only return a value when the workbook that I am linked to is open. Can it be done?


Posted by Dave Hawley on March 15, 2001 10:31 PM


Unfortunately Andy, both the INDIRECT and CELL functions require the Workbook to be open.

Have you looked at Hyperlinks ?

Dave

OzGrid Business Applications