If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hyperlink problem and question
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 |
#2
|
|||
|
|||
Hyperlink problem and question
Make sure you have the current version of Reader:
http://www.adobe.com/support/downloa...13&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") Shawn wrote: 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 |
Thread Tools | |
Display Modes | |
|
|