hyperlink
 

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

hyperlink
 

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 wrote:

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

hyperlink
 

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

"Dave Peterson" wrote:

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 wrote:

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

hyperlink
 

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!

stew wrote:

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

"Dave Peterson" wrote:

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 wrote:

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


--

Dave Peterson