Excel 2003 in ASP.NET & C#

[Prasad Patil]

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

[CMM]

RE: Excel 2003 in ASP.NET & C#

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.

"Prasad Patil" wrote:
[color=blue]
> 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[/color]