Cute PDF Automation

Hi,

I am working on CutePDF writer to convert excel file into PDF. I have created Print Button which selects the range on the worksheet and prints it out with the Cute PDF writer. The problem is , it opens a pop up asking me where I should save the file to and also the filename. Is there any way I can automate this i.e. setting input file name and output file name without any user prompt?

I am giving you the code below.

Sub PrintIt()

' Set active Printer to CutePDF
SetDefaultPrinter ("CutePDF Writer") ' I can include the code for this function upon request

Range("A1:J43").Select
Selection.PrintOut Copies:=1

End Sub

This might help as it talks about registry keys.

http://www.cutepdf.com/solutions/pdfwriter3.asp

Thanks
Kapil

Cute PDF does work with VBA. But the problem I am solving for works only with their Custom Edition i.e. bypassing save as dialog box is possible only for their custom edition. But the good news is I have solved the problem with Bullzip PDF Printer. This printer is completely programmable and free as well..