close

=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 

arrow
arrow
    全站熱搜

    xiaolabaDIY 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄