Mike Molyneaux wrote:
Is there a way via VB to examine the active printer & see
how many print jobs are waiting? If possible, I know I can
come up with a routine to wait until the print queue is
clear or at some threshold.
Since I don't know of such a means, I would just put in an
Application.Wait Now+TimeValue("0:0:20") ' or whatever
in the loop between printing each workbook.
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup