My department updates a slew of excel files which we occasionally print in large quantities. On a select few files, if the Active Printer is not changed, individual sheets will print out with the same printer settings that they were printed with last time, even if the default settings of the printer has changed.
On a small collection of files which need to be printed in a specific order, I had a VB script running through the list, switching the active printer to an imagewriter driver (because the switch is faster than switching to another printer), and then switching back to the desired printer.
That is still slow, as it takes about 1.5-2.5 seconds to change the active printer.
So, is there a way to avoid this issue?
On a small collection of files which need to be printed in a specific order, I had a VB script running through the list, switching the active printer to an imagewriter driver (because the switch is faster than switching to another printer), and then switching back to the desired printer.
That is still slow, as it takes about 1.5-2.5 seconds to change the active printer.
So, is there a way to avoid this issue?
