Problem with calling managed code dll from Excel

Question

Hello!
I try to use an assembly I created in C# in Excel.
I use the commands csc, tlbexp & regasm to create the necessary files. I can use the library without any problem on my computer.
When I try to make the assembly work on another computer, I copy the dll and tlb file to the other machine and run regasm there. I can add the reference to the file out of Excel, but when I want to use my object in the VBA-code I get the Error message
"Run-time error '-2147024894 (80070002)'
Automation Error
The system cannot find the file specified"
Does anyone know what to do?
Thanks in advance!
w.

Mathieu Lafontaine · Answer

Hi!  I've had a similar problem.  It seems Excel will only load one version of the .Net framework.  Therefore, it might not use the correct version to execute your assembly.  I added an Excel.exe.config file where Excel.exe resides.  I used an element in the Xml file to specify the framework version of my .Net assembly.  Like this:
I don't know if it'll solve your problem but it helped for mine...

Johan Roman · Answer

See:
http://www.c-sharpcorner.com/Forums/ShowMessages.aspx?ThreadID=38333

ivo.derado · Answer

You need to use the /codebase option when you run regasm. You have to use this option unless you add the assembly to the gac.
Dex