Solved: Printing multiple worksheets to a single pdf file

[andrewvanmar]

Ooh, I came with a good last question: if I want the pdf to always have the samename as the active workbook does,
[vba]sPDFName = "Consolidated.pdf"
sPDFPath = ActiveWorkbook.Path & Application.PathSeparator
Set pdfjob = New PDFCreator.clsPDFCreator[/vba]
can that be done with something like Actveworkbook.name?

edit:
Yay! replace "consolidated" with Activeworkbook.name works to make it have the workbook name.and it works!

is there also code to have the script open the folder it is saved to? (something with activeworkbook.path)?