to open a pdf file from excel
 

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

--
BD3

to open a pdf file from excel
 

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/


"bigdaddy3" wrote:

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

--
BD3

to open a pdf file from excel
 

tried that nothing happened
--
BD3


"chijanzen" wrote:

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/


"bigdaddy3" wrote:

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

--
BD3