VB.NET error using EXCEL

[Juan Sanchez]

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.

 

[Dino Chiesa [Microsoft]]

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?

 

[Juan Sanchez]

Yes, it was working good but this morning I had installed
the office XP PIAs becouse I need use word too.

 

[Robert Jacobson]

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]

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.

 

[Robert Jacobson]

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.