I'll try to keep it simple to be understood.
I have a sheet (
Sheet1; not multiple sheets!) with pages layout (yes, A4-size layout of pages, as seen in Print View). So in Sheet1 I have pages 1, 2, 3 and 4. I have a userform that allows me to print any or some of these four pages, and it prompts for "Number of copies" via spinbutton for each desired page. All this works OK.I need to use Windows's 'Print to PDF' virtual printer to output a PDF. Not XPS, or 3rd parties software - out of the question. I imagine I could export/save to PDF via macro, but am not very sure. Why all the fuss? Because later this PDF will be moved to a pendrive, which will be plugged into office's physical, network-isolated printer machine that does not allow anyone set the amount of copies -don't ask, please-.
Now... Example of daily routine: I need Page 1 (let's say 3 copies) and Page 3 (let's say 17 copies).
BUT (here it comes!), my macro code with
PrintOut From:=1, To:=1, Copies:=3
and
PrintOut From:=3, To:=3, Copies:=17
generate, one by one, 3+17=20 separate PDF files-each contains one single page.
SO. QUESTION IS: how could I make it to PrintOut the 3+17 copies into one single PDF file? Even one PDF with (Page1)x3 and other with (Page3)x17 copies would be nice.
Thank you all.