Tech Support Guy banner
Status
Not open for further replies.

Help with excel macros print

1K views 5 replies 3 participants last post by  Bronwon 
#1 ·
#5 ·
So much for the easy answer.... I just love these generic 1004 errors that Excel throws at us.

Ok. The error message indicates that the macro cannot find the printer being called. So, tackling this in a couple of ways comes to mind.
  1. After your "Application.ActivePrinter..." line, try adding "debug.print application.activeprinter" to find the actual printer name.
    • And/Or
  2. Build an OnError/Resume/Next check to loop through the range (NE00 - Ne16) of network printer port numbers. It is my understanding that these port numbers may change dynamically.
Good Luck.
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top