Launching other apps

  • Thread starter Thread starter MattB
  • Start date Start date
M

MattB

I'd like to launch a non office application (Adobe Reader)
and have it print a chosen document from a macro. I can
do this with DDE commands for microsoft apps, but not for
acrobat reader. Am I doing something wrong or is there
another method? All help appreciated.

Matt
 
Acrobat reader may not support DDE - I can't say, but I have done it using
the shell command and send keys.

From a previous post:

had luck using the Shell command:

Sub Tester2a()
Shell "C:\Program Files\Adobe\Acrobat 5.0\Reader\AcroRd32.exe" & _
" c:\toc1\amcr37-4.pdf", 1
' the following prints the document
Application.SendKeys "^p~", False
End Sub

or if you have .pdf associated with acrobat reader:

Private Sub CommandButton1_Click()
Shell "Start.exe ""D:\My Documents\sm569_Jan2001\tute6.pdf"""
Application.SendKeys "^p~", False
End Sub
 
Back
Top