Printable View
I have a macro that send several sheets to be printed to the printer one at a time for formatting purposes. When someone else sends a job to the printer while the macro is running, sheets get mixed up.
Is there a way to "reserve" the printer until all the sheets have been sent by the macro to the printer so that they all come out on after the other. The printer would then go on and print whatever was sent to the printer while the macro was running.
Max
Might this question have been better off in another section?
As far as I know the only way(s) to preserve sheet order when doing a big(ish) print job are:
a: Stand by the printer and gaurd it like a man with a pot of gold
b: Send the print job as a single document
c: Shout out and tell everyone not to print.
But how well used is this printer surely the jobs arrive 1234 so fast no other print jobs can get in the list of jobs? Do you not have a print-server or is the printer on the network without being first connected to a PC?
What are you trying to control? Without that knowledge I have no idea how to control the print order of the network. Additionally what rights (if known) does your login and your PC have on the network Admin or user?
Thanks Mat,
Maybe it is impossible to do it.
Here is what I am trying to control : I have maybe 15 sheets to be printed. Each of them has different printing set ups and I run a macro to set up each of them and send them to the printer seperately. The whole process takes about 30 seconds maybe so there is good chances that a job is sent while one of my macro is running.
M-A