File name question

S

stew

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

display contents of cell in another workbook 7
File path 8
Copy and Paste Question 12
Locating cell using Hyperlink 10
Address 5
Vlookup or Hlookup 8
ongoing hyperlink problem 3
ongoing question re hyperlink 4

Top