[µo°Ý] ¦p¦óVBA¤£«ü©w³nÅé¶}±Ò¯S©wÀÉ®×

morris_lth

¤§©Ò¥H­n³o¼Ë°Ý¬O¦]¬°,¤U­zµ{¦¡¤¤«ü©w"C:\Program Files\Adobe\Reader 8.0\Reader\AcroRD32.exe"
¨Ó¶}±ÒPDFÀÉ®×,¦ý¬O¦¹excel Àɮ׬O©ñ¦b¤½¥Î¸ê®Æ§¨¤¤,¶}Àɪº¤H¥¼¥²¨Ï¥Îªº³nÅé©Î¬O¸ô®|·|¬OReader 8.0,
¦³¥i¯à¬O9.0,¦³¥i¯à¸ô®|¤£¬OC:\........

©Ò¥H¤~·Q¸ß°Ý¬O§_¦³¤è¦¡¥uµ¹Àɮ׸ô®|,¦Ü©ó¶}ÀɳnÅ骺¸ô®|ºØÃþ¨Ìuser¥»¨­¹q¸£¨Ó¨M©w´N¦æ

Private Sub CommandButton1_Click()
Shell "C:\Program Files\Adobe\Reader 8.0\Reader\AcroRD32.exe \\fileserver\PUB\QA\11 SIP\SIP\QCS001-MT1097X.pdf", vbNormalFocus
End Sub

stillfish00

¦^´_ 1# morris_lth
try this
ActiveWorkbook.FollowHyperlink "\\fileserver\PUB\QA\11 SIP\SIP\QCS001-MT1097X.pdf"

Joforn

1. #If VBA7 Then
   
2.   Private Declare PtrSafe Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteW" (ByVal hWnd As LongPtr, ByVal lpOperation As LongPtr, ByVal lpFile As LongPtr, ByVal lpParameters As LongPtr, Optional ByVal lpDirectory As LongPtr = 0^, Optional ByVal nShowCmd As ShowCM = 1) As Long
   
3. #Else
   
4.   Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteW" (ByVal hWnd As Long, ByVal lpOperation As Long, ByVal lpFile As Long, ByVal lpParameters As Long, Optional ByVal lpDirectory As Long=0, Optional ByVal nShowCmd As ShowCM = 1) As Long
   
5. #End If
   
6. 
   
7. Public Enum ShowCM
   
8.   SW_SHOWNORMAL = 1&
   
9.   SW_SHOWMINIMIZED = 2&
   
10.   SW_SHOWMAXIMIZED = 3&
    
11.   SW_SHOWNOACTIVATE = 4&
    
12.   SW_SHOW = 5&
    
13.   SW_SHOWMINNOACTIVE = 7&
    
14.   SW_SHOWNA = 8&
    
15.   SW_SHOWDEFAULT = 10&
    
16. End Enum
    
17. 
    
18. 
    
19. Public Function ShellOpenFile(ByVal FileName As String, Optional ByVal ShowMode As ShowCM = 1)
    
20.   If Len(FileName) Then
    
21.     ShellOpenFile = ShellExecute(Application.hWnd, StrPtr("open"), StrPtr(FileName), 0, , ShowMode)
    
22.   End If
    
23. End Function
    
24. 
    
25. Sub Test()
    
26.   ShellOpenFile "\\fileserver\PUB\QA\11 SIP\SIP\QCS001-MT1097X.pdf" '¥i¥H¬O¨ä¥¦ªº¤å¥ó¦W¡A¥u­n¨t²Î¯à°÷ÃѧOªº¤å¥óÃþ«¬¡A³£·|¦Û°Ê¥HWindowsÀq»{µ{¦¡¶}±Ò«ü©wªº¤å¥ó¡C¤ñ¦p«ü©wªº¬O.TXT¤å¥ó¡A±N·|¦Û°Ê¥HNotepad.exe¶}±Ò
    
27.   ShellOpenFile "https://www.facebook.com/profile.php?id=100010420125898", SW_SHOWMAXIMIZED  '¶}±Òºô­¶
    
28.   ShellOpenFile "MailTo:[email protected]" 'µo°eEmail¨ì«ü©wªº¶l½c¦a§}
    
29. End Sub

½Æ»s¥N½X

­ã´£³¡ªL

¸Õ¸Õ¡G
VBA.CreateObject("WScript.Shell").Run """\\fileserver\PUB\QA\11 SIP\SIP\QCS001-MT1097X.pdf"""

morris_lth

ÁÂÁÂ,¤j®aªº¤èªk³£¤£¿ù