Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Variabilize File Path or File Name in SumProduct (and Vlookup too) | Excel Worksheet Functions | |||
Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
file path | Excel Discussion (Misc queries) | |||
file path | Excel Discussion (Misc queries) | |||
Excel updating from XML file - file path specific? | Excel Discussion (Misc queries) |