473,385 Members | 1,867 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

VB.NET error using EXCEL

Hi there,

I have a VB.NET application using EXCEL it run fine in
some computers but now in a specific one I receive the
error QueryInterface for interface Excel._Application
failed. interop.Excel.

Some body can help me ?
Thanks in advance.
Jul 21 '05 #1
6 3785
Excel must be installed on the machine, is it?
and, the excel interop assemblies must be installed.
Also, the version of Excel must match the version of the interop assembly.

Are all these things true?

--
Dino Chiesa
Microsoft Developer Division
d i n o c h @ o n l i n e . m i c r o s o f t . c o m
"Juan Sanchez" <em**************@yahoo.com> wrote in message
news:03****************************@phx.gbl...
Hi there,

I have a VB.NET application using EXCEL it run fine in
some computers but now in a specific one I receive the
error QueryInterface for interface Excel._Application
failed. interop.Excel.

Some body can help me ?
Thanks in advance.

Jul 21 '05 #2
Yes, it was working good but this morning I had installed
the office XP PIAs becouse I need use word too.

-----Original Message-----
Excel must be installed on the machine, is it?
and, the excel interop assemblies must be installed.
Also, the version of Excel must match the version of the interop assembly.
Are all these things true?

--
Dino Chiesa
Microsoft Developer Division
d i n o c h @ o n l i n e . m i c r o s o f t . c o m
"Juan Sanchez" <em**************@yahoo.com> wrote in messagenews:03****************************@phx.gbl...
Hi there,

I have a VB.NET application using EXCEL it run fine in
some computers but now in a specific one I receive the
error QueryInterface for interface Excel._Application
failed. interop.Excel.

Some body can help me ?
Thanks in advance.

.

Jul 21 '05 #3
Do you have Excel XP installed on all of the client machines? The Office
PIAs are only compatible with Office XP (not Office 2000 or earlier.)
"Juan Sanchez" <em**************@yahoo.com> wrote in message
news:04****************************@phx.gbl...
Yes, it was working good but this morning I had installed
the office XP PIAs becouse I need use word too.

-----Original Message-----
Excel must be installed on the machine, is it?
and, the excel interop assemblies must be installed.
Also, the version of Excel must match the version of the

interop assembly.

Are all these things true?

--
Dino Chiesa
Microsoft Developer Division
d i n o c h @ o n l i n e . m i c r o s o f t . c o m
"Juan Sanchez" <em**************@yahoo.com> wrote in

message
news:03****************************@phx.gbl...
Hi there,

I have a VB.NET application using EXCEL it run fine in
some computers but now in a specific one I receive the
error QueryInterface for interface Excel._Application
failed. interop.Excel.

Some body can help me ?
Thanks in advance.

.

Jul 21 '05 #4
NO, I don't have XP installed, then I want to roolback the
PIAs installation, I had follow the steps recomended on
documentation but the error continue.

-----Original Message-----
Do you have Excel XP installed on all of the client machines? The OfficePIAs are only compatible with Office XP (not Office 2000 or earlier.)

"Juan Sanchez" <em**************@yahoo.com> wrote in messagenews:04****************************@phx.gbl...
Yes, it was working good but this morning I had installed the office XP PIAs becouse I need use word too.

>-----Original Message-----
>Excel must be installed on the machine, is it?
>and, the excel interop assemblies must be installed.
>Also, the version of Excel must match the version of the
interop assembly.
>
>Are all these things true?
>
>--
>Dino Chiesa
>Microsoft Developer Division
>d i n o c h @ o n l i n e . m i c r o s o f t . c o m
>
>
>"Juan Sanchez" <em**************@yahoo.com> wrote in

message
>news:03****************************@phx.gbl...
>> Hi there,
>>
>> I have a VB.NET application using EXCEL it run fine

in >> some computers but now in a specific one I receive the >> error QueryInterface for interface Excel._Application
>> failed. interop.Excel.
>>
>> Some body can help me ?
>>
>>
>> Thanks in advance.
>
>
>.
>

.

Jul 21 '05 #5
You just need to remove the references to the PIAs in your project. After
that, add a reference to the COM type libraries for the versions of Excel
and Word that are installed on the client machines.

If the clients are using Excel 2000, for example, you need to reference the
Excel 9.0 type libraries. (Under the Add Reference: COM tab.) You need to
have that version of Excel installed on your development machine.
"Juan Sanchez" <em**************@yahoo.com> wrote in message
news:2d****************************@phx.gbl...
NO, I don't have XP installed, then I want to roolback the
PIAs installation, I had follow the steps recomended on
documentation but the error continue.

-----Original Message-----
Do you have Excel XP installed on all of the client

machines? The Office
PIAs are only compatible with Office XP (not Office 2000

or earlier.)


"Juan Sanchez" <em**************@yahoo.com> wrote in

message
news:04****************************@phx.gbl...
Yes, it was working good but this morning I had installed the office XP PIAs becouse I need use word too.
>-----Original Message-----
>Excel must be installed on the machine, is it?
>and, the excel interop assemblies must be installed.
>Also, the version of Excel must match the version of the interop assembly.
>
>Are all these things true?
>
>--
>Dino Chiesa
>Microsoft Developer Division
>d i n o c h @ o n l i n e . m i c r o s o f t . c o m
>
>
>"Juan Sanchez" <em**************@yahoo.com> wrote in
message
>news:03****************************@phx.gbl...
>> Hi there,
>>
>> I have a VB.NET application using EXCEL it run fine in >> some computers but now in a specific one I receive the >> error QueryInterface for interface Excel._Application
>> failed. interop.Excel.
>>
>> Some body can help me ?
>>
>>
>> Thanks in advance.
>
>
>.
>

.

Jul 21 '05 #6
You just need to remove the references to the PIAs in your project. After
that, add a reference to the COM type libraries for the versions of Excel
and Word that are installed on the client machines.

If the clients are using Excel 2000, for example, you need to reference the
Excel 9.0 type libraries. (Under the Add Reference: COM tab.) You need to
have that version of Excel installed on your development machine.
"Juan Sanchez" <em**************@yahoo.com> wrote in message
news:2d****************************@phx.gbl...
NO, I don't have XP installed, then I want to roolback the
PIAs installation, I had follow the steps recomended on
documentation but the error continue.

-----Original Message-----
Do you have Excel XP installed on all of the client

machines? The Office
PIAs are only compatible with Office XP (not Office 2000

or earlier.)


"Juan Sanchez" <em**************@yahoo.com> wrote in

message
news:04****************************@phx.gbl...
Yes, it was working good but this morning I had installed the office XP PIAs becouse I need use word too.
>-----Original Message-----
>Excel must be installed on the machine, is it?
>and, the excel interop assemblies must be installed.
>Also, the version of Excel must match the version of the interop assembly.
>
>Are all these things true?
>
>--
>Dino Chiesa
>Microsoft Developer Division
>d i n o c h @ o n l i n e . m i c r o s o f t . c o m
>
>
>"Juan Sanchez" <em**************@yahoo.com> wrote in
message
>news:03****************************@phx.gbl...
>> Hi there,
>>
>> I have a VB.NET application using EXCEL it run fine in >> some computers but now in a specific one I receive the >> error QueryInterface for interface Excel._Application
>> failed. interop.Excel.
>>
>> Some body can help me ?
>>
>>
>> Thanks in advance.
>
>
>.
>

.

Jul 21 '05 #7

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

Similar topics

0
by: ICE Srl | last post by:
Hi everybody I am trying to build an ASP.Net application to create dinamically an Excel File on the server. I am trying using this VB code Public Sub CreateExcelForm( Dim MyExcel As...
17
by: Ange T | last post by:
Hi there, I'm having pain with the VB behind an Access form. The form is used to create reports in Excel based on the details entered in the form. This has always worked without error on my...
1
by: Jimmer | last post by:
I've got what should be an easy automation problem, but the solution simply isn't coming to me. I've got several public variables set up for automation as follows: Public gappExcel As...
6
by: Rich Wallace | last post by:
Hi all, I have a VB app that runs and manages individual XLS files within a single COM object. Upon processing the final fie, I attempt to close out the EXCEL object and release it using...
5
by: Juan Sanchez | last post by:
Hi there, I have a VB.NET application using EXCEL it run fine in some computers but now in a specific one I receive the error QueryInterface for interface Excel._Application failed....
4
by: Mark | last post by:
Hello - I receive the error message: System.Runtime.InteropServices.COMException: The remote procedure call failed. when I open an Excel file using from an ASP.Net page. Imports...
4
by: Neo | last post by:
I found on error resume next doesn't work in for each... e.g. on error resume next for each x in y 'do stuff next if you have an error in for each loop, it falls in infinite loop... it...
1
vinci
by: vinci | last post by:
Please help me out... i only have two weeks to do it... here is my code: Dim ex As New Object Dim wb As Excel.Workbook Dim sheet As Excel.Worksheet
2
by: RohitGBhagwat | last post by:
Hi, I am New To ASP.Net and I have created a small application in ASP.Net using C# which is a reporting Tool. In this Application I have to Edit an Excel File on a Weekly basis and for that i am...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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,...
0
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...
0
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,...
0
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...

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.