Distribute COM DLL made with VB.NET

Question

Hello, I am experiencing a problem when I want to use a DLL made with VS.Net in VB.NET. I have a COM Class that create a DLL and a TLB file. I can reference the TLB in VBA and use the DLL in VBA on my computer, where I develop. The problem is that it is not working on other computer..? I tried to register the DLL with regasm.exe (although it looks like it is register during the compilation on my developement machine). The error in VBA is a bit meaningless, such as "Cannot create ActiveX component". Also, if you have any link that would help me to understand the registering mechanism that would be great. The wikipedia page of DLL is foggy for me. Thanks in advance, Swan

Answer 1

hi

I tried. I create a MSI project inside my solution, it linked it with dependency nicely. When I deploy on another machine, I have that error in VBA (while reading the dll)

Automation error The system cannot find the file specified

any Idea ?