View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Robert ap Rhys Robert ap Rhys is offline
external usenet poster
 
Posts: 21
Default 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