Link to home
Start Free TrialLog in
Avatar of wander4heat19
wander4heat19

asked on

StartDoc Printer Calll error

Hello experts--


There is an error that I do not understand what it relates to and I remember getting this error early on and I forgot what I did to make it go away.  However, a colleague has been trying to run my macro and when she tries to use the populate macro to copy a bunch of sheets to a template, she gets an error:

Microsoft Visual Basic for Applications
System Error ....HEX (-2147021893) - A StartDocPrinter Call was not issued,

I do not know what this is.  All the macro does is open another '.xlsm' and then copies over about 25 '.xls' onto it.  I can run it without an error, but when she tries she gets this error.

Thanks for your help!
wander
ASKER CERTIFIED SOLUTION
Avatar of dlmille
dlmille
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I checked other related posts.  Make sure - e.g., from notepad or something, that she can print to network printers.  Find out what LPT1 is pointing to, if anything.  And, having detected this as a problem, correct the security on the printer (why would printers need password protection?) and eliminate it, or correct the password on her machine in making the connection.

Hope this helps!

Dave