The three matrix that I have validated and shared are
Thanks for the great post.
In the project I am working, we have both excel 2010 and 2013 which needs to be tested. Our coded UI test is created based on 2010 visual studio and we are about to upgrade to VS 13 update 2.
Is there any way to automate the tests for both versions of excel using only one solution ? It would be quite difficult to arrange the continuous integration with two different builds.
Thank you for the plugin. I'm using Excel 2013 X VS 2013 version. But i do not find the specified "Microsoft.VisualStudio.Test.Sample.UI.dll" (the second dll is ok)
In additional, what do i need to do after finding and copying this dll?
To reference these dlls in my CodedUI project?
To add my CodedUI project under your solution?
Thank for the update, the solution is really helpful! Keep it up!
I use Excel 2013 and VS2013 update 5. I've compiled the solution, copied assemblies to specified locations, then unchecked CodedUIAddinHelper in Excel options and finally run your solution (Excel has been starded as you said). Up to that point everything is alright. Unfortunatelly when I try to record test using Coded UI Test Recorder, it crashes. After that I unchecked your add-in from COM Add-ins and checked CodedUIAddinHelper - now everything works fine! I can access cells while recording Coded UI test and tests pass. Do you know why is it working in such a configuration?
And the most important question: Source code is distributed with no license - can I use use it and extend in my commercial project?