Problem Calling .NET dll from Excel VBA

[brazilnut52]

Say I have a .NET project to compile to a class library (.DLL). Here is all the code in the library:

Public Class GetString 

    Public Function GetTestString() As String 
        Return "Test String" 
    End Function 

End Class

In the build options, I have selected the library to be Registered for COM Interop. After compiling the project, I get both GetString.dll and GetString.tlb in the \bin folder.

Now in Excel I open a new book. Go to the Vb Editor and add a reference to the GetString.tlb file in the \bin folder of my .NET solution. I then add VBA module and I put the following code:

Public Sub getStr() 
    Dim str As New GetString.GetString 
    Dim ws As Worksheet 
    Set ws = ActiveSheet 
    ws.Range("A1").Value = str.GetTestString() 
End Sub

Compile -> Save. When I run the macro, everything works perfect! The string is successfully placed in the appropriate cell.

But NOW the part that has confused and frustrated me for a long time. I now take the Excel worksheet, the GetString.dll, and the GetString.tlb file and put them on another computer. The other computer does have .NET installed by the way. When I run the macro, I get the following error: Run-time error '429': ActiveX component can't create the object.

This problem is a much more simplified version of what I am actually dealing with. But If someone could PLEASE tell me the exact steps to take to get this macro to work on a PC other than my own development PC, I would be very greatful.

Thanks,
brazilnut