Sorry Pete
This is accepted formula
=HYPERLINK(LEFT(CELL("Filename",A1),SEARCH("[",CELL("filename",A1))-25)&"Merchandise Package\[Mechandise Spreadsheet.xls]Mechandise Spreadsheet'!
A"&((ROW()-4)*103+8),"View")

THE PATH SHOWS UP AS TAKING ME TO A111 WHICH IS THE CORRECT CELL BUT STILL
THE PROMPT " CANNOT OPEN SPECIFIED FILE" COMES UP

ANY THOUGHTS

STEW

"stew" wrote:

Hi Pete
=HYPERLINK(LEFT(CELL("Filename",A1),SEARCH("[",CELL("filename",A1))-25)&"Merchandise Package\[Mechandise Spreadsheet.xls]Mechandise Spreadsheet'!
A"&((ROW()-4)*103+8),"View"

is accepted as a formula and View shows up.

THE PATH SHOWS UP AS TAKING ME TO A111 WHICH IS THE CORRECT CELL BUT STILL
THE PROMPT " CANNOT OPEN SPECIFIED FILE" COMES UP

"stew" wrote:

Dear Pete

Thanks again for looking at this
=HYPERLINK(LEFT(CELL("Filename",A1),SEARCH("[",CELL("filename",A1))-25))&"MÂ*erchandise Package\Mechandise Spreadsheet.xls"

exactly as you see it gets me to Merchandise spreadsheet. If I add \. IT
ALSO DOES THE JOB

IF I ADD THE CHANGES IN THE WAY YOU SUGGEST IT WILL NOT ACCEPT THE FORMULA.
iF i REMOVE "vIEW" THE FORMULA IS ACCEPTED BUT WHEN I TRY TO USE COMES BACK
WITH THE PROMPT " CANNOT OPEN SPECIFIED FILE".

THE PATH SHOWS CORRECTLLY

ANY THOUGHTS

sTEW

"Pete_UK" wrote:

Hello again, Stew.

You will need the sheet name as well as the column letter and row
number, but you will also need to have square brackets around the
filename and two apostrophes. So, try this:

=HYPERLINK("'"&LEFT(CELL("Filename",A1),SEARCH("[",CELL("filename",A1))-25))&"MÂ*
erchandise Package\[Mechandise Spreadsheet.xls]Sheet1'!
A"&((ROW()-4)*103+8),"View")

I assume that the LEFT function does return the full path to that
point and ends in \.

Hope this helps.

Pete

On Nov 4, 8:29 pm, stew wrote:
Hi all

In this Formula how would one add the exact cell you would want to open at
=HYPERLINK(LEFT(CELL("Filename",A1),SEARCH("[",CELL("filename",A1))-25))&"MÂ*erchandise Package\Mechandise Spreadsheet.xls"
Ideally it would be along the lines of "&((ROW()-4)*103+8),"View")

Thanks

Stew