ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Pdf PrintOut and SendKeys (https://www.excelbanter.com/excel-programming/352654-pdf-printout-sendkeys.html)

Philippe

Pdf PrintOut and SendKeys
 
Hi,

I'm desperately trying to automate clicking on the save button of PDFWriter
v5 dialog box.

Do you know how to use these sendKeys ?
I never did it, It seems damned simple, but I still can't get it to work !

This is one of the lines i've tried :
SendKeys "{ENTER}", False
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:="Acrobat
PDFWriter"

Thanks in advance for any comments.
Philippe

Robert ap Rhys

Pdf PrintOut and SendKeys
 

"Philippe" wrote in message
...
Hi,

I'm desperately trying to automate clicking on the save button of

PDFWriter
v5 dialog box.

Do you know how to use these sendKeys ?
I never did it, It seems damned simple, but I still can't get it to work !

This is one of the lines i've tried :
SendKeys "{ENTER}", False
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:="Acrobat
PDFWriter"


PDFWriter v5 supports a registry setting for bypassing this dialog box. I
think the setting is HKEY_CURRENT_USER\Software\Adobe\Acrobat
PDFWriter\PDFFileName. Set this to the filename you require. Note that when
the 'printing' has finished this registry setting will be wiped, so you can
poll it until it disappears before you attempt to print another copy.

HTH

Robert





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

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