The laserjet 5si printer down the hall can print duplex. I use it heavily along with the 4 pages per sheet options. This save lots of paper, and dramatically reduces the size of my file drawers.
Excel remembers my last settings and uses them whenever I click the print icon.
But, Excel's memory is much better than mine. At least once a week I'll print an important document for mailing to a client, then walk to the printer and discover it is 4up two sided when I wished it was 1up single sided (simplex). Very annoying cause I have to return to my desk and reprint the document.
I once spent several hours trying to adapt the logic in Q230743 to do the job, and another hour seaching for similar links. Something went wrong and I gave up. I can't even recall what it was that wouldn't work.
Unfortunately, I do not have time to tackle the programming myself especially knowing that I tried and failed once before.
So, I am asking if anybody already has working code which will do the job with minimal modifications?
Please, only post answers if you can personally vouch that the solution works. I don't have time to chase a bunch of false leads. Normally I enjoy the challenge, but not right now.