473,326 Members | 2,182 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Office dependencies

I've been given an app to deal with that has a dependency on Excel XP (I
think it was also known as Excel 2002). I have Office 2003 installed on
my box. The application does not compile (complains of a missing
assembly). Basically it complains about the following:

Error: The dependency 'Interop.Microsoft.Office.Core, Version=2.3.0.0,
Culture=neutral' in project 'Lan.Mers.Processor' cannot be copied to the
run directory because it would conflict with dependency
'Interop.Microsoft.Office.Core, Version=2.2.0.0, Culture=neutral'.

What can I do to make it compile without having to uninstall office 2003
and installing office xp? Removing the dependency on excel is not on
the table (believe me, i asked).

Regards
Sep 1 '06 #1
1 3893
Try the following:

1. Open solution explorer and expand the References tab. You may see an item
appearing with a yellow exclamation mark. This is an item needing attention.
Remove the reference to Excel.
2. Close the project and re-open it.
3. In solution explorer right click on References and select Add Reference.
4. In the Add Reference form select COM and scroll down to Microsoft Excel
5.0 Object Library. Select it and click OK.
5. Try building your project. If it fails then you may need to look at the
using statements or code statements using the Interop as I have seen
differences between name spaces used (even on the same version of Office).

You should be able if the code is constructed correctly to allow your
application to work with both versions of Excel. I've a VS 2005 project
which quite happily automates versions of Word from 2000 through to 2003.

HTH

- Andy

"Frank Rizzo" <no**@none.comwrote in message
news:eL**************@TK2MSFTNGP06.phx.gbl...
I've been given an app to deal with that has a dependency on Excel XP (I
think it was also known as Excel 2002). I have Office 2003 installed on
my box. The application does not compile (complains of a missing
assembly). Basically it complains about the following:

Error: The dependency 'Interop.Microsoft.Office.Core, Version=2.3.0.0,
Culture=neutral' in project 'Lan.Mers.Processor' cannot be copied to the
run directory because it would conflict with dependency
'Interop.Microsoft.Office.Core, Version=2.2.0.0, Culture=neutral'.

What can I do to make it compile without having to uninstall office 2003
and installing office xp? Removing the dependency on excel is not on the
table (believe me, i asked).

Regards

Sep 1 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Zamolxe | last post by:
I have installed the Visual Studio 2003 FULL With MSDN (ORIGINAL NOT CRACKED :), Office 2003PRO FULL. After installing Office i have insatlled the MSDE form OFFICE CD, IIS is installed. Then:...
2
by: JT Lovell | last post by:
I have a solution with 5 projects and I need them to build in a particular order. I understand that setting the project dependencies will allow this, but when I go to the Project Dependencies...
1
by: R Reyes | last post by:
ISSUE (reposted) =========================== Can someone please explain to me why I can't get the MS Word Interop assembly to work in my VS2005 project? For many people, they say they add the...
5
by: SJ | last post by:
I have a VS2005 solution that has a class library and a website. Website has a project reference to the class library in the solution. Whenever I try to build the solution the following two lines...
7
by: barias | last post by:
Although circular dependencies are something developers should normally avoid, unfortunately they are very easy to create accidentally between classes in a VS project (i.e. circular compile-time...
9
by: sajithkahawatta | last post by:
my web page C#.net is work properly in my iis .but when i publish in another server it give errers.i used vs2005 and ms word 2003. but in the server there is no vs2005 or word installed. it has only...
8
by: Scott Sauyet | last post by:
I found myself needing to find my way recursively through a document in XSLT, finding the dependencies one element had on others, and including only those in an initial set, their dependencies, the...
0
by: pankajprakash | last post by:
as i run the my web application it occurs the following error "Could not load file or assembly 'Microsoft.Office.Interop.MSProject, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'...
3
OuTCasT
by: OuTCasT | last post by:
Hi I have created an asp.net project that exports items from datagridview to and outlook calendar This is the code that i have used.. Dim body As String Dim ends As String ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.