Print a PDF File from within Excel
Is it possible for an excel macro to call up and print a
PDF file. |
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. |
All times are GMT +1. The time now is 08:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com