Excel 2003 in ASP.NET & C#

[Guest]

Hi,

I have installed Office 2000 & Office 2003 on my Machine

I wish to use excel 2003 in my Dot Net Project

When I reference the Microsoft Excel 5.0 Object library the code

using Excel works fine

When i reference the Microsoft Excel 11.0 Object library the code

using Excel gives an error "Type or namespace name 'Excel' could not be
found or missing"

I have taken this project from the previous developer on whose machine the
project is working fine with excel 2003.


Is this a problem because there are two different versions of Office on the
machine


Does anyone know the solution, pls suggest

Regards,
Prasad

 

[Guest]

It's conceivable that the multi-installation is the culprit. I don't know...
but, my own experience in the past with having to code for multiple versions
of office is that most often it's a lot more helpful to reference the Office
application's .OLB type library rather than their COM registration in the
Registry. Hope that helps.