Dealing with printer errors

[tmktech]

Howdy Tek-Tippers!

I'm hoping to tap into that vast wealth of knowkedge again.
Here' my question / dilemma:

I've got an EXCEL/VBA module that generates hardcopy, along with other (PDF, CSV, TXT, etc.) files for multiple "entities".

I've got all of the error handling in place (since this is a proprietary module), but my problem is that I'm aborting the code sometimes for unforeseen printer issues. The latest appears to be a spooler (possibly full) issue, but I'm not sure. I've instructed my customer to select the "begin printing immediately" option, but I can't depend on that in every case.

I've reluctant to put in an error-handler for a "1004 - printout method failed", because it could be for a number of reasons.

Any suggestions?

Thanks in advance!!
TMKTECH

 

[RobBroekhuis]

I think that approach (error handler) is probably your best bet. Why are you reluctant to use it? Even with a number of different causes, I'd think you can handle the situation similarly for each case?
Rob

 

[PaulTEG]

Why not just divert your output to a folder, and have an operator attend to it, and while its user attended any printer issues can be resolved at their leisure, and not annoy you in any way.

It used to be like this in the old days

HTH
;P

 

[tmktech]

Thanks, Rob & Paul, for confirming my thoughts. I was wandering if there was a different approach outside my paradigm.

I've got the error handling in and I'm putting in the print-to-file as well. It just means another utility to copy to the printer port (no big deal).

Thanks!

TMKTECH