D
Doug
Is there a way in VBA to access the active printer queue
to see if print jobs are hanging, and if so delete them?
In an Excel VBA macro, I'm printing a worksheet to a PDF
file, and sometimes the Adobe converter program crashes
and won't let me keep printing unless I go to "Printers"
and delete the job that caused it to crash. Then ,the
rest of the jobs in the queue go OK. In VBA code, I'd
like to know if a print job has an error and if so I'd
like to delete it from the queue. Anything?
to see if print jobs are hanging, and if so delete them?
In an Excel VBA macro, I'm printing a worksheet to a PDF
file, and sometimes the Adobe converter program crashes
and won't let me keep printing unless I go to "Printers"
and delete the job that caused it to crash. Then ,the
rest of the jobs in the queue go OK. In VBA code, I'd
like to know if a print job has an error and if so I'd
like to delete it from the queue. Anything?