Hello,
I am doing a vba code (at excell ) that open an website (with microsoft IE), and print the page. I need to print with pdf creator that I have istalled. I can tell to my macro to choose the pdf printer but I stopped at the dialog box for choose the destination path. Id like to say automatic to pdfcreator that I want folder a, b, or c.. that I choose that I choose. The destination may change often.
Is there a way to preset the destination folder before job printing?
sub bla()
.......
'at this point my page is already loaded and ready to print
ie.ExecWB OLECMDID_PRINT, OLECMDEXECOPT_DONTPROMPTUSER, 0, 0
Set PDFCreator1 = New clsPDFCreator
With PDFCreator1
.cOption("UseAutosave") = 1
.cOption("UseAutosaveDirectory") = 1
.cOption("AutosaveDirectory") = Range("A1").Value
Debug.Print Range("A1").Value
.cOption("AutosaveFilename") = "Novo salvamento "
.cOption("AutosaveFormat") = 0 ' 0 = PDF
.cClearCache
End With
ie.ExecWB OLECMDID_PRINT, OLECMDEXECOPT_DODEFAULT
end sub
Where do I missing??
Thanks