Use printer in Word without changing default?

[Stu Dapples]

Hi guys!

I have written a bit of code to capture some info which is then printed ona Dymo label printer. I have all the user form working OK, it prints to the Dymo fine....

Problem is, by using the code

application.activeprinter = "DYMO LabelWriter 450"

Application.Printout

Debug.Print Application.ActivePrinter

It changes the Windows default printer to the Dymo! This is not good as someone will, sooner or later, send an A3 document to it and use a roll of labels!!

Is there a way to slect the printer temporarily but not change the windows default?

Been searching but getting near to hair tearing now!

In anticipation,

Stu

 

[GuitarMaker81]

I registered for the sole purpose of issuing a bump! Ideally, one would use a variable to store the current active printer, change to the LabelWriter, print the job, then revert to the originally active printer. It's entirely possible that you found the answer to this elsewhere, but I'm still looking. No hair-tearing, though...

 

[marka87uk]

That's how I'd do it...

CurrentPrinter = Application.ActivePrinter
Application.ActivePrinter = "DYMO LabelWriter 450"
Application.Printout
Application.ActivePrinter = CurrentPrinter