File name question
 

Hi all

I use the following to lift out and display data from another work book,
closed or open.
='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting
Package\Road Managers Package\[Tour Managers Spreadsheet.xls]Tour managers
Spreadsheet'!C111
Is there a Formula, using filename function that could replace the
='C:\Users\Welcome\Stewarts Files\Road accounting program
Part of the routing

I have the Following in a Hyperlink but cannot seem to combine to get the
desired result
=HYPERLINK("["&LEFT(CELL("Filename",$A$1),SEARCH("[",CELL("filename",$A$1))-25)&"Road
Managers Package\Tour Managers Spreadsheet.xls]'Tour Managers
Spreadsheet'!b"&((ROW()+100)),"View")

Hope you can Help and thanks for Looking

Stew