harrisc
11-07-2007, 04:08 PM
Hi
I have a a macro running in Word 2003 to print a label on a networked label printer, by switching to the label printer, print the label (with some formatting) and then switch back to the default printer (also networked). All works well except the macro takes 25 seconds to complete. By stepping through the macro I find that the commands that take all the time are
Application.ActivePrinter = LabelPrinter (switch to label printer)
ActiveDocument.PrintOut Copies:=nNumberCopies, Range:=sPrintRange, Background:=False
strActivePrinterApplication.ActivePrinter = strActivePrinter (switch to default)
I have found that same problem on another computer where the printers are directly connected and not on a network.
Has anyone any ideas on how to speed up this macro?
Thanks
Chris
Adelaide
Australia
I have a a macro running in Word 2003 to print a label on a networked label printer, by switching to the label printer, print the label (with some formatting) and then switch back to the default printer (also networked). All works well except the macro takes 25 seconds to complete. By stepping through the macro I find that the commands that take all the time are
Application.ActivePrinter = LabelPrinter (switch to label printer)
ActiveDocument.PrintOut Copies:=nNumberCopies, Range:=sPrintRange, Background:=False
strActivePrinterApplication.ActivePrinter = strActivePrinter (switch to default)
I have found that same problem on another computer where the printers are directly connected and not on a network.
Has anyone any ideas on how to speed up this macro?
Thanks
Chris
Adelaide
Australia