473,722 Members | 2,459 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

QueryInterface for interface Excel._Applicat ion failed

The company I work for still uses Excel97. In a weaker moment I added the pia for Excel2003 in attempt to get more programatic functionality out of some Excel interfaces I have been writing. The pia is entitled 'Microsoft.Offi ce.Interop.Exce l.dll' I also added the registry entries for that pia by running 'Microsoft.Offi ce.Interop.Exce l.dll.reg.' After performing that stunt the following code consistantly fails on the second line

excelApp = new Excel.Applicati onClass()
excelApp.Visibl e = true

I can declare the new 'Excel.Applicat ionClass(). Unfortunately every time I run 'excelApp.Visib le = true' my program fails with the error

'QueryInterface for interface Excel._Applicat ion failed.

I have since manually removed 'Microsoft.Offi ce.Interop.exce l.dll.' The automatic removal of that pia failed. I have painstakingly removed the registry entries for the same. Can anyone explain what it is that I have failed to remove? Is it possible that I need to add something back into the registry for the Excel97.dll to run properly? If so what is that something. Thank you for any assistance you may be able to provide.

---
Posted using Wimdows.net Newsgroups - http://www.wimdows.net/newsgroups/
Nov 18 '05 #1
1 2374
This article should help you get your Excel code working one way or another:
http://www.aspnetpro.com/NewsletterA...200309so_l.asp

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"Michael Connerton" <connertm@-NOSPAM-squared.com> wrote in message
news:eQ******** ******@TK2MSFTN GP12.phx.gbl...
The company I work for still uses Excel97. In a weaker moment I added the pia for Excel2003 in attempt to get more programatic functionality out of
some Excel interfaces I have been writing. The pia is entitled
'Microsoft.Offi ce.Interop.Exce l.dll' I also added the registry entries for
that pia by running 'Microsoft.Offi ce.Interop.Exce l.dll.reg.' After
performing that stunt the following code consistantly fails on the second
line:
excelApp = new Excel.Applicati onClass();
excelApp.Visibl e = true;

I can declare the new 'Excel.Applicat ionClass(). Unfortunately every time I run 'excelApp.Visib le = true' my program fails with the error:
'QueryInterface for interface Excel._Applicat ion failed.'

I have since manually removed 'Microsoft.Offi ce.Interop.exce l.dll.' The automatic removal of that pia failed. I have painstakingly removed the
registry entries for the same. Can anyone explain what it is that I have
failed to remove? Is it possible that I need to add something back into the
registry for the Excel97.dll to run properly? If so what is that something.
Thank you for any assistance you may be able to provide.
---
Posted using Wimdows.net Newsgroups - http://www.wimdows.net/newsgroups/

Nov 18 '05 #2

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

Similar topics

0
417
by: Jason | last post by:
I'm writing a small console app in .NET that needs to reference a 3rd party dll. I wrote the app by adding a reference to the 3rd party dll in my project and my code builds and executes perfectly. However, when I made a setup file and installed it on another box, I get: System.InvalidCastException: QueryInterface for interface...Failed. when the console app tires to reference the dll. I can see that the
1
2275
by: KC | last post by:
Hi Gurus, I am having problem opening an excel file from vb.net. My code looks like this: Dim EXL as Excel.Application Dim wrkbook As Excel.Workbook EXL = GetObject("", "Excel.Application") EXL = CreateObject("Excel.Application") wrkbook = EXL.Workbooks.Open("D:\Book1.xls")
0
1244
by: Deeps | last post by:
Hi I have created an interface called IGlobal with some properties exposed with a fixed Guid. Created a class inherting this interface. This is my com+ server. I have a client instantiating this object with prog id. I made a build and installed the application, everything works fine. Now, I changed the interface to add one more property and implemented in the class. call it form my client. Rebuild. Now i get an exception...
4
4921
by: Ram | last post by:
I am running a test web site on my own Win2k professional computer. I have a VB6 COM component (running on COM+) on a seperate application runnint as "Server". When running an ASP.NET page calling this component, it works fine, but When I try and debug the Com+ process using the VB6.0 IDE, I get the following error: "Exception Details: System.InvalidCastException: QueryInterface for interface MyObject._MyCls failed." When I the same...
2
2263
by: Dominique MILLOT | last post by:
Hello, With Asp.Net, I try to generat a document with an Excel object. This is the begin of my procedure: Dim xapExcel As Excel.Application xapExcel = New Excel.Application() xapExcel.Visible = False At the last line I obtain this error:
1
1308
by: Ugo | last post by:
Hi, I have just followed the Microsoft Knowledge Base Article - 302084 How to Automate Microsoft Excel from Microsoft Visual C# .Net http://support.microsoft.com/default.aspx?kbid=302084 and I keep getting the following error in a message box: QueryInterface for interface Microsoft.Office.Interop.Excel._Allication failed. Line: Microsoft.Office.Interop.Excel The error is firing when executing the following line : oXL.Visible= true;
1
1330
by: adiel_g | last post by:
Hello, I have created a activeX dll in vb6 that contains some functions I am using in .NET. I created the dll in vb6 with: Instancing = 5-Multiuse MTSTransactionMode = 2-RequiresTransaction Persistable = 0-NotPersistable I then created a COM+ application, set the user to an admin in the COM+ settings and added the dll above as a component. Then from ASP.NET, I added a reference to the dll created above. Everything was fine (on my
1
2835
by: Joseph | last post by:
I have been using "XMLHTTPClass" in an asp.net module. It is properly referenced and was working up until recently. Now it is failing with the error message "QueryInterface for interface MSXML2.IXMLHTTPRequest failed" when I attempt to use the open method of this object. I would appreciate help on this. I have searched high and low on the net - without any success. Thanks, Joseph
2
3249
by: Stan | last post by:
Hello All: Don;t know if this is the correct group to post this in but here goes. Getting this error when trying to create excel object using Outlook Web Components on our web server. Any help would be appreciated. If this isn't the correct group, can someone direct me to the correct one. Error: QueryInterface for interface Excel._Application failed.
0
8867
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
8740
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9386
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...
0
9239
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9090
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6685
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
4503
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...
0
4764
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3208
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

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.