hyperlink


S

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
 
Ad

Advertisements

D

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")
 
S

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

Dave Peterson said:
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
 
Ad

Advertisements

D

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

Dave Peterson said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top