How do I add a VSTO project as a reference to a unit testing project?

Question

In order not to pollute my projects with unit tests, I like to create a separate project for my unit tests; I add a reference to the project under test in the unit tests project. However, this isn't working that well with my VSTO excel add-in projects: when I create a separate unit test project and go to Add Reference > Projects, there is no project to pick.
What I have done so far is Add Reference > Browse, and pick the add-in dll from the debug folder. I have also run into issues from time to time with this, with the reference suddenly not working, requiring to remove/re-add the dll reference.
Can anybody explain why a VSTO project doesn't show up as a regular project? And is there a better way to go about it than what I am doing presently?

Answer 1

I just had the same problem when trying to add a VSTO addin project reference to a WIX setup project. My solution was to manually add the project reference by editing the target project file in notepad. Just find an existing ProjectReference xml tag in the project file, copy it, and replace the file path details, name, etc.

More of a workaround than a solution, but I hope it helps. Not sure what is different about the VSTO addin projects that prevents them from being shown in the add references dialog.