ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Close a foreign application - ADOBE (https://www.excelbanter.com/excel-programming/321895-close-foreign-application-adobe.html)

quartz[_2_]

Close a foreign application - ADOBE
 
I have the following function which opens ADOBE and prints a PDF file from
Excel VBA. This function leaves ADOBE open after printing.

Does anyone know how to get a reference to ADOBE and close ADOBE or how to
alter the following so ADOBE is closed when done? TIA.

Public Function PDFPrintFile(argAdobeAppFullName As String,
argPDFFileToPrintFullName As String)
'START ADOBE APPLICATION AND PRINT A FILE
Shell argAdobeAppFullName & " /p /h " & argPDFFileToPrintFullName
End Function



All times are GMT +1. The time now is 08:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com