Print Multiple sheets with 1 click in reverse order

Hi all,

I have created a document with a dialog box and depending on the selection chosen on this box, it prints out a number of different worksheets.

Currently it works fine, whilst I am printing on my Brother Laser Printer as it prints out each page face down. When I select to print on my other printer (Epson), it prints the pages face up and therefore completely backwards order.

Is there a way to change the order depending on the printer chosen (or maybe I could add a checkbox in my current dialog box if I know that I am printing from my Epson instead).

Appreciate any help and thank you in advance for your time.

Dee

One option would be to make the printers behave the same as each other:
Have you looked at the printing preferences for the Epson printer?
How is the default print sequence set for that printer?
You should be able to select Front-to-Back OR Back-to-Front

Originally Posted by kev_

One option would be to make the printers behave the same as each other:
Have you looked at the printing preferences for the Epson printer?
How is the default print sequence set for that printer?
You should be able to select Front-to-Back OR Back-to-Front

Hi Kev,

I have looked into this, but when the sheets get printed, they are printing like 1 document at a time, therefore in the Brother they happened to be in the correct order, but in the Epson they are reversed. (Not sure if I am making any sense).

Dee

I do not understand your answer
So I will ask different questions and arrive at the answer from a different direction.

You say that you are printing out a number of different worksheets - let's say ws1, ws2, ws3
I presume each worksheet contains multiple pages.

Q1 In which exact sequence do your pages CURRENTLY appear for each printer?
Eg
- Brother ws1(pg 1) THEN ws1(pg 2) THEN ws1(pg 3) THEN ws2(pg 1) etc
- Epson ws3(pg 2), ws3(pg 1), ws2(pg 3), ws2(pg 2), ws2(pg 1) etc

Q2 In which sequence do you want the EPSON pages printing? (so that they end up in the correct sequence and the correct way up on the printer)

Q3 Are you using VBA to control printing? If so please paste your VBA code into your reply
Thanks

I am using a userform in VBA to select the sheets that need to be printed off.

eg:

Please Login or Register  to view this content.

Each sheet has only 1 page to print out.

When I click the command button, it proceeds to print out the required sheets as individual print jobs. On both printers, they print out in the same order, however the Brother printer prints them out face down into the tray and therefore in order and the Epson prints them face up in the tray and therefore backwards.

If they were printing as 1 print job, then they would appear in the correct order in both printers.

Run this macro first to find VBA reference for each printer - this will print values that you need to cells A1 and A2 or (using Debug.Print) to the immediate window in VBA (when in VB window - show Immediate Window with {CTRL} G)

Please Login or Register  to view this content.

Below is your macro altered to give you a choice of printer.
Simply amend where indicated by pasting in the ActivePrinter values discovered by FindActivePrinterNames.

Please Login or Register  to view this content.

Thank you so much for taking the time to help me out.

Looking at it, it makes sense and I will give this a try when I am back from work (heading away for a few days for work), so I'll let you know how it goes when I get back.

Thank you in advance (I am sure this will work).

Dee

You are welcome

Thanks Kev,

With a little tweaking that was a great option.

Works fine.

Unfortunately with the 1 job at a time, the Epson is much slower to print that the Brother.

Dee

I have no solution for that!