Hello,

I need to create automatic PDF from an excel workbook,

The only vba code you gave seems to work only as a UserForm.

What if I need to create a module which is able to create PDF of identified pages at the openning of the workbook?

In module the code :

Private WithEvents PDFCreator1 As PDFCreator.clsPDFCreator

With PDFCreator1
.cOption("UseAutosave") = 1
.cOption("UseAutosaveDirectory") = 1
.cOption("AutosaveDirectory") = ActiveWorkbook.Path
.cOption("AutosaveFilename") = outName
.cOption("AutosaveFormat") = 0 ' 0 = PDF
.cClearCache
End With

seems to not working...

Please would you be so kind, to give an "automatic" way to create PDF with module and with sheets' selection by name?

Thank you so much for that.