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