Solved: Printing multiple worksheets to a single pdf file

[andrewvanmar]

@charlize
Again one step closer: I added the code, but instead of printing to the pdf creator it printed to my default printer. (strrrrrange....)
After I changed the default printer to the pdfcreator to see what would happen i just get the error message "cant initialise pdfcreator" apparantly, thepdf printer name i entered wasn't right yet.

How do Icheck the printer name? ( i looked in printers and faxes, but the name there is just pdfcreator) and probably more importantly how do I fit it in the code.

There is something else I dont get, unrelated to the code: if I print to pdf manually, it does the whole printing thing along with a filename dialogue, but no location dialogue ( and I can't find the files it has supposedly made. Something I missed there?

@paul
same result, apart from the printing to my colour printer