Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Launching other apps
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Launching other apps
Hi Matt
for automating Adobe Acrobat you may have a look at http://partners.adobe.com/asn/develo...ocs/iacref.pdf -- Regards Frank Kabel Frankfurt, Germany MattB wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Launching other apps
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 -- Regards, Tom Ogilvy "MattB" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help - Alt-E hotkey does not work in MSOffice apps, no prob in other apps | Excel Discussion (Misc queries) | |||
OLE switching <- Apps | Excel Programming | |||
Handling Excel Apps? | Excel Programming | |||
Linking to other VB apps | Excel Programming | |||
Linking to other VB apps | Excel Programming |