How can I use a .Net dll in vba on a users machine

Question

I can access the dll in question on my dev machine and have created a .Net setup project. On a VM I install the setup.exe and it installs .Net. After installing I can see all of the public members when I use it in Excel vba but when I run it I get either "429 can't create object" or "Automation error".

Answer 1

It sounds like you've got the registration correct, so the next question is what version of Visual Studio are you using and what version of Excel? There were two hotfixes put out for VS2005/Excel 2003, one for the build machine (which I can't find...) and one for the client workstation. If you're using these two together you may want to apply that patch to the client workstation.

Answer 2

The setup project wasn't properly referencing my dll.