Software

Ask something
Discussion Locked

Excel error - no printers installed

0 helpful
3 replies

by walt.schaff

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'm trying to create VB executable that accesses Excel (2000) as an OLE Automation object and prints selected worksheets. I want to run the program from the AT scheduler. The program works fine in debug and the executes when launched from Windows Explorer, but fails from the scheduler. The program returns a 1004 run time error that no printers are installed.

3 replies

by mtnsqs

When you run from the scheduler you are not logged in as who you think you are - you need to create a bacth job, that sya swho you are and put output to a file. Then setup the pritners for that user.
On NT4 AT jobs ran as system (i think)

by walt.schaff

Answer is partually right. Applications running from the NT scheduler run as a system account. No default printer is defined for the system account. You need to update the registry. See MSDN Support article ID Q152451 for details.

This discussion is closed to new replies.