| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
| EXCEL wont open from Explorer, must open EXCEL then find file | Excel Discussion (Misc queries) | |||
| In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
| Open email windows can't open, excel shreadsheet file .xls ? | Excel Discussion (Misc queries) | |||
| How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel | |||
Hybrid Mode
