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

Usually safest to use CELL("FILENAME",A1) rather than CELL("FILENAME")
See Excel help for the CELL function.
--
David Biddulph

"stew" wrote in message
...
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

Hi David

I have changed that but other than that does the formula look right? Still
no success

Best

Stew

"David Biddulph" wrote:

Usually safest to use CELL("FILENAME",A1) rather than CELL("FILENAME")
See Excel help for the CELL function.
--
David Biddulph

"stew" wrote in message
...
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

If you want to open the file to a specific worksheet, you're going to have to
include a specific cell, too (A1???).

Untested:

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



stew wrote:

Hi David

I have changed that but other than that does the formula look right? Still
no success

Best

Stew

"David Biddulph" wrote:

Usually safest to use CELL("FILENAME",A1) rather than CELL("FILENAME")
See Excel help for the CELL function.
--
David Biddulph

"stew" wrote in message
...
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





--

Dave Peterson

Hi dave

What I am trying to , I have now discoverd, does not require a Hyperlink
I am trying to replace a straight forward file path, shown below

='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting
Package\Production Managers Package\[Production Managers
Spreadsheet.xls]Production Managers Spreadsheet'!D111

With

=MID(CELL("filename"),1,FIND("[",CELL("filename"))-25)&"Production Managers
Package\[Production Managers Spreadsheet.xls]Production Managers
Spreadsheet'!D111"

=MID(CELL("filename"),1,FIND("[",CELL("filename"))-25) gives me

C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting
Package\

So what am I doing wrong?

Best

Stewart



"Dave Peterson" wrote:

If you want to open the file to a specific worksheet, you're going to have to
include a specific cell, too (A1???).

Untested:

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



stew wrote:

Hi David

I have changed that but other than that does the formula look right? Still
no success

Best

Stew

"David Biddulph" wrote:

Usually safest to use CELL("FILENAME",A1) rather than CELL("FILENAME")
See Excel help for the CELL function.
--
David Biddulph

"stew" wrote in message
...
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





--

Dave Peterson

..
Hi all

Ok Improvement but Still not sucessful

This is the file path I am trying to generate

='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting
Package\Production Managers Package\[Production Managers
Spreadsheet.xls]Production Managers Spreadsheet'!D111

I have now used

=("="&"'"&(MID(CELL("filename"),1,FIND("[",CELL("filename"))-25)))&"Production
Managers Package"&"\"&"["&"Production Managers
Spreadsheet.xls"&"]"&"Production Managers Spreadsheet'!D111"

Which gives me

='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting
Package\Production Managers Package\[Production Managers
Spreadsheet.xls]Production Managers Spreadsheet'!D111

However it shows the formula and not the result

Can anybody help!!!

Best

Stewart

"stew" wrote:

Hi dave

What I am trying to , I have now discoverd, does not require a Hyperlink
I am trying to replace a straight forward file path, shown below

='C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting
Package\Production Managers Package\[Production Managers
Spreadsheet.xls]Production Managers Spreadsheet'!D111

With

=MID(CELL("filename"),1,FIND("[",CELL("filename"))-25)&"Production Managers
Package\[Production Managers Spreadsheet.xls]Production Managers
Spreadsheet'!D111"

=MID(CELL("filename"),1,FIND("[",CELL("filename"))-25) gives me

C:\Users\Welcome\Stewarts Files\Road accounting program\Road Accounting
Package\

So what am I doing wrong?

Best

Stewart



"Dave Peterson" wrote:

If you want to open the file to a specific worksheet, you're going to have to
include a specific cell, too (A1???).

Untested:

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



stew wrote:

Hi David

I have changed that but other than that does the formula look right? Still
no success

Best

Stew

"David Biddulph" wrote:

Usually safest to use CELL("FILENAME",A1) rather than CELL("FILENAME")
See Excel help for the CELL function.
--
David Biddulph

"stew" wrote in message
...
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





--

Dave Peterson