examine print queue from vb

  • Thread starter Thread starter Mike Molyneaux
  • Start date Start date
M

Mike Molyneaux

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 said:
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.
Click to expand...

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
 
Back
Top