Moq & Interop Types: works in VS2012, fails in VS2010?

by

Edit : It works for me when I try it in Visual Studio 2012 and target .Net 4.0, only using the .Net PIA’s not the COM ref. Same solution doesn’t work in VS2010.

VS2010 loads version’s 10.0.30319.1 of the Microsoft.VisualStudio.QualityTools.UnitTestFramework.dll's and VS2012 loads version’s 11.0.50727.1. You can see the different version’s in the Modules window.

I managed to get it working in VS2010:

enter image description here

Here is my solution http://temp-share.com/show/Pf3Ypip62 for everyone’s convenience. It has all the Moq references included. I have Excel 2007 (ie v12) – so please adjust references to Office 14.

The Project with methods to be Tested has to use the PIA Microsoft.Office.Interop.Excel via the .Net reference tab.

In the Unit Test Project you have to use the Microsoft Excel 1X.0 Object Library via the COM reference tab – its an ActiveX.

The confusing thing is in Solution Explorer they are both called: Microsoft.Office.Interop.Excel

There is one other caveat that I dont know how to workaround – you have to use the .Net 3.5 framework and I was actually hoping Microsoft fixed it in 2012 as you found because I cant work how to do it with ALL projects in .Net 4.0. Some solutions with mixed projects targeting .Net 3.5 & 4.0 are ok.

I’ve had a lot of trouble with this, see here How do I avoid using dynamic when mocking an Excel.worksheet? and also see this question I asked: Mocked object doesn’t have all properties shown in Intellisense – in one project but has them in the other.

Anyway this is how to get it working in VS 2010. I’m glad its resolved in 2012!

More Related Contents:

  1. How to cut up a string from an input file with Regex or String Split, C#?
  2. Closing Excel Application Process in C# after Data Access
  3. Is there a format code shortcut for Visual Studio?
  4. The type or namespace name could not be found [duplicate]
  5. Assigning out/ref parameters in Moq
  6. Unable to load DLL ‘SQLite.Interop.dll’
  7. two different DLL with same namespace
  8. Mocking HttpClient in unit tests
  9. How do I get the currently-logged username from a Windows service in .NET?
  10. Console application closes immediately after opening in visual studio
  11. How to run a test many times with data read from .csv file (data driving)
  12. Dependent DLL is not getting copied to the build output folder in Visual Studio
  13. Cannot close Excel.exe after Interop process
  14. Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE))
  15. Controlling execution order of unit tests in Visual Studio
  16. How can I change IIS Express port for a site
  17. Setting the datasource for a Local Report – .NET & Report Viewer
  18. Mocking EF DbContext with Moq
  19. WiX – Install Prerequisites and 3rd party applications
  20. Can you use optional parameters in code targeting .NET 3.5?
  21. IIS Express Immediately shutting-down running site after stopping web application
  22. How to mock Controller.User using moq
  23. streamWriter rewrite the file or append to the file
  24. How do I compile my App.config into my exe in a VS2010 C# console app?
  25. How to (should I) mock DocumentClient for DocumentDb unit testing?
  26. WPF C# InputBox
  27. C# Compiler optimization – Unused methods
  28. Properly disposing of, and removing references to UserControls, to avoid memory leak
  29. Override Paste Into TextBox
  30. C# 6.0 Support in Visual Studio 2012

Leave a Comment