Excel Interop "No printers are installed" error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a VB.NET console application that uses the Excel PIA. I set it up to
run on a W2K box through Task Scheduler, under a domain account that has
rights to all of the resources the app uses. I can run this application on
my local XP machine with no problem. However, on the W2K machine I received a
"No printers are installed" error:

System.Runtime.InteropServices.COMException (0x800A03EC): No printers are
installed.

The app sets the workbook's LeftFooter attribute, which of course requires
that a printer be set up on the machine. There are not one, but six printers
set up on the W2K box, with a network printer set as the default. The
Everyone group has rights to this printer. Why can my application not see
this? What can I do to correct this error?

TIA,
 
Solved, and it wasn't a problem with the interop; it was a context and
permissions situation. The account running the AT didn't have a printer in
its profile. I ran the job under the user with the printer assigned, which
corrected that problem. I also had to give it rights to the data involved,
but that's a story for another day.
 
Back
Top