I' running excel 2000 on nt 4, sp6.

My users have win 98, excel 2000, pentium 350, 64mb ram
(don't laugh).

I've used you guys' help to write macros to reduce the
manual gyrations these users used to go thru & I
appreciate all the help you've provided.

So here I am again.

Every Monday & Friday they need to open 48 different
workbooks and print two to four pages (with formatting)
from two sheets. They were doing this manually.

I am able to do this with macros.

Problem occurs when only networked printer available is
backed up with jobs.

They begin to get various system (I think) errors
indicating a problem within the 'activesheet.pagesetup'
routine. These routines are used for all 48 workbooks &
don't fail unless the network printer is backed up.

Ok, all that to get here.

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.

As always I appreciate any and all help.

Thanks - Mike

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

thanks, i'm sure that will do the trick.