How to use two different Microsoft Interop assemblies in one project ?

Question

I want to use two different Microsoft.Office.Interop assemblies (version 11 and 12) depending on the Office version installed on customer's machine.

I've been able to add these two asseblies to my project ( I am using them loccaly - they are in my bin folder, in two diffrent subfolders) , I used aliases on this assemblies to be able to use both of them in my project (respectively, aliases are Excel11 and Excel12).

But unfourtunately, when I am trying to build the solution I am getting warning:

No way to resolve conflict between "Microsoft.Office.Interop.Excel, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" and "Microsoft.Office.Interop.Excel, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c". Choosing "Microsoft.Office.Interop.Excel, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" arbitrarily.

Answer 1

Perhaps my blog post on this subject will help.

HTH, Kent