hyperlink help

[Shawn]

I have this


\\Pwreports\PWREPORTS\2010\197\2010000005_NIBRS Incident Report.pdf


I can make the hyper link work once, ( flashes real fast and disappears)


I need change two things the 197 and 2001000005
The 197 is the ofc badge and is located in cell bh6 and the 2010000005 is
the case number and is located in cell au6 but when i change it to the
cells in which the info is it doesn't work no more

The link refers to a drive in which the ofc's report is located , its
under year\ofc badge number\case number underscoreNIBRS Incident
Report.pdf

 

[Pete_UK]

Try this formula:

=HYPERLINK("\\Pwreports\PWREPORTS\2010\"&BH6&"\"&AU6&"_NIBRS Incident
Report.pdf","Open PDF")

Hope this helps.

Pete

 

[Dave Peterson]

Check one of your other posts.

I have this

\\Pwreports\PWREPORTS\2010\197\2010000005_NIBRS Incident Report.pdf

I can make the hyper link work once, ( flashes real fast and disappears)

I need change two things the 197 and 2001000005
The 197 is the ofc badge and is located in cell bh6 and the 2010000005 is
the case number and is located in cell au6 but when i change it to the
cells in which the info is it doesn't work no more

The link refers to a drive in which the ofc's report is located , its
under year\ofc badge number\case number underscoreNIBRS Incident
Report.pdf