hi,
I write a dll and register it by following command,
and excel use the dll by add it as a reference .
%SystemRoot%\Microsoft.NET\Framework\v2.0.50727\regasm.exe regasmxp.dll /tlb:regasmxp.tlb /codebase
It works fine in the develop machine but not in another machines.
The error message is [-2147024894 - File or assembly name regasmxp, or one of its dependencies, was not found.]
What's wrong ? Someone can help me?
//---------------c#
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Runtime.InteropServices;
namespace regasmxp
{
[InterfaceType(ComInterfaceType.InterfaceIsDual)]
[Guid("01A31113-9353-44cc-A1F4-C6F1210E4532")] //Allocate your own GUID
[ComVisible(true)]
public interface _Test
{
int addnum(int a, int b);
}
[ClassInterface(ClassInterfaceType.None)]
[Guid("E2F07CD4-CE73-4102-B35D-119362624542")] //Allocate your own GUID
[ProgId("regasmxp.Class1")]
[ComVisible(true)]
public class Class1 : _Test
{
public Class1()
{
}
public int addnum(int a, int b)
{
return a + b;
}
}
}
//------------vba
Dim a as regasmxp.Class1
set a = New regasmxp.Class1
MsgBox a.addnum(4 , 5)