473,796 Members | 2,532 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Excel Interop "No printers are installed" error

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,

--
Phil Hegedusich
Senior P/A
IIMAK
----
A skeleton walks into a bar and says, "I need a beer and a mop."
Jul 18 '06 #1
1 16675
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.
Jul 19 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1977
by: Raquel | last post by:
Have installed UDB PE V8.0 on Win XP and wrote a JDBC program using driver com.ibm.db2.jcc.DB2Driver. At run time, it throws error "No Suitable Driver". Why is it? When I use JDBC-ODBC bridge sun.jdbc.odbc.JdbcOdbcDriver (instead of the above driver), the program runs fine. TIA Raquel.
4
9547
by: amywolfie | last post by:
I would like to put code behind a Find button on a form which: 1) Performs a find based on a field on the form 2) If NO RECORDS ARE FOUND, then displays a custom "No Records Found" message box. Thanks!! amy ===
0
1609
by: feng | last post by:
Hi, I am having a strange problem right now and I don't even know how to go about it. Someone please help me! Any inputs will be highly appreciated. We have an application that has a VB.Net windows form front-end and a middle tier that's also in VB.Net. The two talk to each other via .Net Remoting. If we just run the windows form exe directly, then the application works just
1
1741
by: Amedee Van Gasse | last post by:
I have written a small vb.net app that creates a Word and an Excel file. I referenced Word, Excel and Office as COM-components. The app does not work on a pc where Word or Excel are not installed. According to this article: http://www.devcity.net/Articles/89/1/spellcheck.aspx I added a try/catch, like this: Imports System.Runtime.InteropServices
1
2721
by: scottmachado | last post by:
I am currently running a marco that run a query and emails the results as an attachment in excel format. If the query has no records, I would like to email "no records found" in the first cell in the excel attachment. I have a feeling that this needs to be done in VB, but I don't know that much about VB. Would using a report instead be a better and easier way of doing this?
0
1264
by: JymBoe | last post by:
I have built a Web Service with a multi-table dataset. When I attempt to discover the Web Service, I get an error saying "ItemsRow has no parameterless constructor" where ItemsRow is a row in the table Items. Since the dataset code is constructed by the IDE why am I getting this error and how do I correct it?
2
3775
by: emallove | last post by:
I'm running into the below "No modules named _sha256" issue, with a python installed in a non-standard location. $ python Python 2.5.2 (r252:60911, May 20 2008, 09:46:50) on linux2 Type "help", "copyright", "credits" or "license" for more information. Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/ws/ompi-tools/lib/python2.5/md5.py", line 6, in <module>
1
4241
by: indikamaligaspe | last post by:
Hi all, I am trying to get a PL/TCL trigger to update an audit table working. The problem is when I create the trigger on an exiting table, I get the following error "ERROR: can't read "tgname": no such variable CONTEXT: can't read "tgname": no such variable while executing ....." If I drop the table and then recreate the table and add the rigger, the trigger works fine. However if I alter the table, again I have to drop and...
1
1995
by: mitica grigore | last post by:
hello i use an access 2002-2003 database under an access 2007 environment and win xp sp3 i have about 24'000 records so far sometimes, when i try to use "back-up database" or "compact & repair database" i obtain the "no current record" error and the process stops even if the progress bar showed some progress before the error occures. give me please a solution. thanks
0
9679
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10453
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10172
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9050
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7546
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6785
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5441
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4115
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2924
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.