=HYPERLINK("http://www.google.com.tw/search?q="&B2&"&safe=active","按這裡在GOOGLE中搜尋B3格子中的字串")
Breakdown for the formula -
=HYPERLINK("PATH" & variable & "PARAMETER","TEXT display")
+++++++++++++++++++++++++++++++++++++++++++++++++
+++++++++++++++++++++++++++++++++++++++++++++++++
Another example for the local drive activation, it is used to display the possibility of such applications. In case a database of individual record has to be linked with local file or the remote one, it is very possible to accomplish the job with the EXCEL and such so a simple approach.
good luck.
=HYPERLINK("C:\Documents and Settings\user0\My Documents\My Music\"&B2,"按此播放B2格子中的歌曲檔案")
+++++++++++++++++++++++++++++++++++++++++++++++++
+++++++++++++++++++++++++++++++++++++++++++++++++
VBA code for the programmatic approach of which is a must, the code snippet following,
Sub open_PDF_file()
Shell "C:\Program Files\Adobe\Acrobat 6.0\Acrobat\Acrobat.exe" _
& " " & _
"\\Remote-Drive\paths\my-file.pdf"
End Sub
文章標籤
全站熱搜
