C# MS Office Version problem

[Jason Huang]

Hi,

In our C# windows form project, we have referenced MS Excel 10.0 in our
project.
However, we have several different versions of MS Excel in our client sites.
How do we fix this problem without changing client's Excel?
Thanks for help.

Jason

[Paul]

This may be over-engineering it, but maybe you could develop a generic
interface for your needs and then create a DLL for each version of Excel
that you need to support. You could then load the relevant DLL using
reflection in your application. Not sure how you'd determine which version
of the DLL to use, if you could do it programatically or need to read it
from application configuration file. If there's no clear way to determine
which version to use, on start up I guess you could increment through the
DLL's trying each in time until you found one that worked. You may only
need to do this once as you could then update the config file with which
version to use. If you needed to support a new version you could then just
supply a new DLL to the relevant client site.
"Jason Huang" <Ja************@hotmail.comwrote in message
news:eF**************@TK2MSFTNGP04.phx.gbl...

Hi,

In our C# windows form project, we have referenced MS Excel 10.0 in our
project.
However, we have several different versions of MS Excel in our client
sites.
How do we fix this problem without changing client's Excel?
Thanks for help.

Jason

[cp]

You could reference the 'lowest' level of Excel (you might get on
client machines) e.g. version 9.0.

cp

Jason Huang wrote:

Hi,

In our C# windows form project, we have referenced MS Excel 10.0 in our
project.
However, we have several different versions of MS Excel in our client sites.
How do we fix this problem without changing client's Excel?
Thanks for help.

Jason

[Jason Huang]

Thanks!
But I have no idea how to code DLL in my project!

"Paul" <no****@noone.com¼¶¼g©ó¶l¥ó·s»D:e6**************@T K2MSFTNGP04.phx.gbl...

This may be over-engineering it, but maybe you could develop a generic
interface for your needs and then create a DLL for each version of Excel
that you need to support. You could then load the relevant DLL using
reflection in your application. Not sure how you'd determine which
version of the DLL to use, if you could do it programatically or need to
read it from application configuration file. If there's no clear way to
determine which version to use, on start up I guess you could increment
through the DLL's trying each in time until you found one that worked.
You may only need to do this once as you could then update the config file
with which version to use. If you needed to support a new version you
could then just supply a new DLL to the relevant client site.
"Jason Huang" <Ja************@hotmail.comwrote in message
news:eF**************@TK2MSFTNGP04.phx.gbl...

>Hi,

In our C# windows form project, we have referenced MS Excel 10.0 in our
project.
However, we have several different versions of MS Excel in our client
sites.
How do we fix this problem without changing client's Excel?
Thanks for help.

Jason