View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Matthias Claes Matthias Claes is offline
external usenet poster
 
Posts: 2
Default Print Acrobat Reader PDF file from VBA

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