Hyperlink problem and question

[Shawn]

I created a hyperlink to a pdf file ,it flashes and closes whats wrong???

\\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 change it to the
cells in which the info is it doesn't work no more I also will CRTL D
after I can get this one line to work...

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


Do I make sense and can you figure this out

 

[Dave Peterson]

Make sure you have the current version of Reader:
http://www.adobe.com/support/downloads/thankyou.jsp?ftpID=2713&fileID=2551

If you used the =hyperlink() worksheet function, you could try:

=hyperlink("File:////\\Pwreports\PWREPORTS\2010\" & bh6 & "\" & au6
& "_NIBRS Incident Report.pdf","click me")

The values in bh6 and au6 may need to be formatted (padded out to 3 or 10
characters):

=hyperlink("File:////\\Pwreports\PWREPORTS\2010\" & text(bh6,"000") & "\"
& text(au6,"0000000000") & "_NIBRS Incident Report.pdf","click me")