Side-By-Side COM Interop with C# and VBA
To add to the already existing answers: with .NET 4.0, it’s actually quite simple to consume a C# dll in your VBA project without registering the COM. EDIT: I just tried this with the mscorlib.tlb and mscoree.tlb that are in C:\windows\Microsoft.NET\Framework\v2.0.50727— loading an assembly compiled in 3.5– and it worked just fine. So apparently you … Read more