View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Philippe Philippe is offline
external usenet poster
 
Posts: 16
Default 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