to open a pdf file from excel

[bigdaddy3]

With the code below i can open adobe acrobat 7 from within excel with a macro
but what i want to do is open an adobe pdf file from my documents folder i
added the code in brackets , adobe opened but said file not found. Any help
appreciated

Shell "C:\Program Files\Adobe\Acrobat 5.0\Reader\AcroRd32.exe ( C:\Documents
& Settings\My Name\My Documents\MyFile.pdf)",vbNormalFocus

 

[chijanzen]

bigdaddy3:

try, ShellExecute API Function

Const SW_SHOW = 5
Private Declare Function ShellExecute Lib "shell32.dll" Alias _
"ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, _
ByVal lpFile As String, ByVal lpParameters As String, _
ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long

Sub test()
Filename = "C:\Documents & Settings\My Name\My Documents\MyFile.pdf"
ShellExecute 0, "open", Filename, "", "", SW_SHOW
End Sub

 

[bigdaddy3]

tried that nothing happened
--
BD3

bigdaddy3:

try, ShellExecute API Function

Const SW_SHOW = 5
Private Declare Function ShellExecute Lib "shell32.dll" Alias _
"ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, _
ByVal lpFile As String, ByVal lpParameters As String, _
ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long

Sub test()
Filename = "C:\Documents & Settings\My Name\My Documents\MyFile.pdf"
ShellExecute 0, "open", Filename, "", "", SW_SHOW
End Sub

--
天行å¥ï¼Œå›å­ä»¥è‡ªå¼·ä¸æ¯
地勢å¤ï¼Œå›å­ä»¥åŽšå¾·è¼‰ç‰©

http://www.vba.com.tw/plog/