We help IT Professionals succeed at work.
Get Started

Does anybody have vba code for macros to PrintDuplex4up PrintSimplex1up

rberke asked
Last Modified: 2012-05-12
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.

Watch Question
This problem has been solved!
Unlock 2 Answers and 18 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE