View Single Post
 
Old 05-06-2020, 12:45 AM
alex100 alex100 is offline Windows 7 64bit Office 2016
Advanced Beginner
 
Join Date: May 2020
Posts: 79
alex100 is on a distinguished road
Default

Thank you, but I'm afraid the issue still persists. Here's how it all goes...

1) i open up a 10 pages document;

2) i print it out using any of the two scripts above;

3) the "flip over" message quickly shows up, AND at the same time the first 5 pages of the document are sent to the printer. However, the printer does NOT start printing them. In the print queue, they all show up with a "Spooling" status;

4) the printer will only start the printing process AFTER I click the "flip over" ok button. This is the point where the printer starts printing the document ("Spooling" status will end), but ALL 10 pages are printed in a row, one after another, leaving me no time to flip over the first set of pages. No difference at all when compared to a regular print job.

I believe the problem lays in the simple fact that Application.PrintOut will not print the pages unless I press the MsgBox ok button, and the macro execution can end. So Application.PrintOut will only print if the script has fully executed and exited.

I tried turning off the print spooler (cmd.exe - > net stop spooler) but that aggravated things even more (the printer was unavailable). I didn't notice any printer driver settings related to how the spooler works.

Another approch would be to execute the script twice, with the first execution printing the first set of pages and saving the print details to a file (start/end page), and the second execution to load these details automatically and go ahead right away with the second half of prints.

What would you advise me, please?

Alex
Reply With Quote