hyperlink

[stew]

Hi all

I am trying to insert a hyperlink in row 11 that will take me to that will
take me to a document which is held in "Cash Payments Receipts Backup"
folder, which is in the same folder as the workbook i am working on. The
document will be the invoice/receipt that relates to the sum of money shown
on row 10. This document will always be a pdf doc and will be named 10

=hyperlink(cash payments receipts backup\row()-1,"pdf") does not do it

Can anybody help

thanks for looking

stew

 

[Dave Peterson]

This expression will return the path that holds your workbook (it has to be
saved at least once).

=LEFT(CELL("Filename",A1),SEARCH("[",CELL("filename",A1))-1)

So we could string all that stuff together:

=HYPERLINK("file:\\\\"
&LEFT(CELL("Filename",A1),SEARCH("[",CELL("filename",A1))-1)
&"cash payments receipts backup\"&ROW()-1&".pdf","PDF")

 

[stew]

Dear Dave

Works a treat. How long have you been working with excel functions. I am
learning but I feel this may take some time!!!

thanks again

stew

This expression will return the path that holds your workbook (it has to be
saved at least once).

=LEFT(CELL("Filename",A1),SEARCH("[",CELL("filename",A1))-1)

So we could string all that stuff together:

=HYPERLINK("file:\\\\"
&LEFT(CELL("Filename",A1),SEARCH("[",CELL("filename",A1))-1)
&"cash payments receipts backup\"&ROW()-1&".pdf","PDF")

Hi all

I am trying to insert a hyperlink in row 11 that will take me to that will
take me to a document which is held in "Cash Payments Receipts Backup"
folder, which is in the same folder as the workbook i am working on. The
document will be the invoice/receipt that relates to the sum of money shown
on row 10. This document will always be a pdf doc and will be named 10

=hyperlink(cash payments receipts backup\row()-1,"pdf") does not do it

Can anybody help

thanks for looking

stew

 

[Dave Peterson]

I think we switched to excel (from Lotus 123) sometime in the early 1990's. But
if you really want to see amazing formulas, then do a little lurking in the
..worksheet.functions newsgroup. Those people are really something!

Dear Dave

Works a treat. How long have you been working with excel functions. I am
learning but I feel this may take some time!!!

thanks again

stew

This expression will return the path that holds your workbook (it has to be
saved at least once).

=LEFT(CELL("Filename",A1),SEARCH("[",CELL("filename",A1))-1)

So we could string all that stuff together:

=HYPERLINK("file:\\\\"
&LEFT(CELL("Filename",A1),SEARCH("[",CELL("filename",A1))-1)
&"cash payments receipts backup\"&ROW()-1&".pdf","PDF")

Hi all

I am trying to insert a hyperlink in row 11 that will take me to that will
take me to a document which is held in "Cash Payments Receipts Backup"
folder, which is in the same folder as the workbook i am working on. The
document will be the invoice/receipt that relates to the sum of money shown
on row 10. This document will always be a pdf doc and will be named 10

=hyperlink(cash payments receipts backup\row()-1,"pdf") does not do it

Can anybody help

thanks for looking

stew