Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() "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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Printout using MFC | Excel Worksheet Functions | |||
no #VALUE! to printout | Excel Worksheet Functions | |||
no #VALUE! to printout | Excel Worksheet Functions | |||
Vba printout | Excel Programming | |||
PRINTOUT | Excel Programming |