Excel Problem....

  • Thread starter Thread starter padu.oombans.friend
  • Start date Start date
P

padu.oombans.friend

Hi
I am doing an automation program using C#.net and MS Excel, I
have some issues regarding the object library.... i was able to run the
application in my system having XP and MS Excel 2003, but it stops
working when i install it in WIN 2000 server with Excel 2000, can any 1
help me with this issue, I did a lot of searching but with no
help....is it due to the COM component i use? I am using the 1 which is
available in the VS 2003 ( Microsoft Excel 11.0 object library ) which
i guess is not compatible with Excel 2000. Any suggetions, plz help
 
If there is a reference to the Excel application in your C# application it
will have to be to the lowest possible Excel version that your application
may have to work with.
I do some coding in VB6 and compile with a reference to Excel 9, otherwise
it won't work with 10 or 11.
The other option is to use late binding, but that has some drawbacks.

RBS
 
Is the problem it will register the add-in (tools->addins->automation.., but
the functions names will not show up?
I have this problem deploying to machines with only Excel version 10
installed. It works on a a machine with dual install Excel v10 and v11 (but
this machine also has VS2005 so may be either VS2005 or office 11 installed
that makes it work on Excel v10 here...
 
I have the same problem however my company policy forces me to work
using windows SP1 (I cannot use the shared addin wizard), and office 10
only.

Any fix for this from microsoft ?
 
I do not know if some other bugs are involved with some Office XP
configurations.

But to fix it, you just have to create an Excel.exe.config file in
\Program Files\Microsoft Office\Office 10\ (or whatever folder contains
Excel.exe)

which contains:

<?xml version ="1.0"?>
<configuration>
<startup>
<supportedRuntime version="v2.0.50727" />
</startup>
</configuration>

If forces Excel to use the framework 2.0.


In order to make your setup project, under VS 2005, click on your setup
project, then View -> Editor -> File System

right click and add a folder called "Microsoft Excel", change the
default location (if you want a clean solution, you need to use the
registry to determine the path for office). Right click it and add
Excel.exe.config, so it will auto deploy.

You can also go into the project properties -> prerequisites and add
the components you need ... (like the framework 2.0)
 
Back
Top