ComServer Example - Can't add a reference to the specified file

[ExcelUser242]

I'm trying to run the sample ComServer in the Excel-Dna Samples but cannot add a reference to the ComServer.dll - ComServer link

The VBA project references show MISSING:ComServer but when I remove the missing reference and link to the newly build it gives error

Can't add a reference to the specified file

I've tried building with Any CPU and x64 with no luck and have tried all of the ExcelDna versions 1.0.0 onwards . Any ideas how to solve this?

Target Framework: .NET 4.7.2
Excel Version: Excel 2016 (16.0.5056.1000) MSO (16.0.5056.1000) 64-bit
<package id="ExcelDna.AddIn" version="1.2.5-preview" targetFramework="net472" developmentDependency="true" />
<package id="ExcelDna.Integration" version="1.2.5-preview" targetFramework="net472" />

[govert]

@ExcelUser242
I think building the COM Server stuff is not so straight-forward yet.
But the write-up I tried in the "DnaComServer" one is better than the first ComServer example that I think you're trying here.
So check this one for a start: https://github.com/Excel-DNA/Samples/tree/master/DnaComServer
You might still need to edit some paths to make it work though, and there might still be problems if I remember from here: Excel-DNA/Samples#11

Sorry - I can't remember the history of the two projects, and it needs to be cleaned up a bit.
If it's urgent, you're welcome to contact me directly to arrange for an online support session.