Office dependencies

[Frank Rizzo]

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

 

[Andy Bates]

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