Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to print a given Acrobat Reader PDF file from VBA. (Office 2000
& Acrobat Reader 6) I've found a solution. using the follwing link http://vb.mvps.org/samples/project.asp?id=HyperJmp Using the ShellExecute WinAPI call, you may execute a 'verb' associated with a file extensions. So, declare ShellExecute as follows in a module: 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 and print your document using the following call: Dim result As Long result = ShellExecute(0&, "print", "\\someserver\somefolder\somefile.pdf", vbNullString, vbNullString, vbNormalFocus) Matthias Claes matthias.claes(-at-)stadsbader.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
can't print to adobe acrobat | Charts and Charting in Excel | |||
how i can take file from adobe reader and make it read with micr. | Excel Discussion (Misc queries) | |||
Opening Acrobat Reader using VBA | Excel Discussion (Misc queries) | |||
Print to Adobe Acrobat (2 ws to one file) | Excel Programming | |||
how sendKeys to Acrobat Reader | Excel Programming |