Thread: File path
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SteW SteW is offline
external usenet poster
 
Posts: 293
Default File path

Hi All

The followig does not display the contents of D111.also it will not open
Tour Managers Spreadsheet , which is the sheet name inside Tour Managers
Spreadsheet Workbook.
In order to to eliminate the actual formula, can anybody see anything
physically wrong with the layout

=HYPERLINK(MID(CELL("FILENAME"),1,FIND("[",CELL("filename"))-10)&"Road
accounting program\Road Accounting Package\Road Managers Package\Tour
managers Spreadsheet.xls]'Tour Managers Spreadsheet'!",D111)

Thanks for looking

Stew