Good Afternoon All.
I am using the following code to specify a label printer that I want data to be printed to.
Application.ActivePrinter = "NPIE46FEC (HP LaserJet M203dw) on Ne01:"
ActiveSheet.PrintOut
What I am trying to figure out though, is SHOULD there be an error and that printer is not available, I need it to go to the regular print dialog box so that the information can still be printed.
How do write something like
If printer is not available, then display print dialog box, else print to activeprinter?
Bookmarks