Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print a PDF File from within Excel
Is it possible for an excel macro to call up and print a
PDF file. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print a PDF File from within Excel
I 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 "Bob Laba" wrote in message ... Is it possible for an excel macro to call up and print a PDF file. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print all worksheets of Excel file to one pdf file | Excel Discussion (Misc queries) | |||
my excel is converting all my print jobs to print to file why? | Excel Discussion (Misc queries) | |||
How do I print from a file created from sending a print to a file | Excel Discussion (Misc queries) | |||
Print Excel file to PDF | Excel Discussion (Misc queries) | |||
FILE Save As / FILE Print greyed out in Excel | Excel Programming |