I did the adaptation with the names, that was my test situation..... this isn't as easy as thought.Originally Posted by Paul_Hossler
@ charlize, there seems to be no activity in pdfcreator, it saves nothing, but also there is no doc qeued
I did the adaptation with the names, that was my test situation..... this isn't as easy as thought.Originally Posted by Paul_Hossler
@ charlize, there seems to be no activity in pdfcreator, it saves nothing, but also there is no doc qeued
When I use the PDF "printer" here it asks me for a file name
Instead of looping to add WS to a PDF file, I was able to select multiple sheets and print them all to a file.
As an experiment, you could start to record a macro, select all your sheets (control+click) at once, and then File, Print selecting your PDF printer.
I got the code fragment in my earlier answer, and guessed at how your macro might look.
[vba]
Worksheets(Array("Information", "IPL Service", "Signatures and pricing")).Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:="PDFCreator", Collate:=True
[/vba]