Error when calling vb dll subroutine from excel vba

[Spence5]

I've created the following dll in vb 2008 which doesn't offer an easy com template/project, thus I used project type "Class Library".

Public Interface IDemo
    Sub doSomething()
End Interface
Public Class implementIDemo
    Implements IDemo
    Dim varAsInterface As IDemo = New implementIDemo()
    Dim varAsClass As implementIDemo = New implementIDemo()
    Private Sub doSomething() Implements IDemo.doSomething
    MsgBox("Hello")
    End Sub
End Class
 

I then used tlbexp.exe, gacutil.exe, regasm,exe, and sn.exe so that the
"doSomething" sub routine could be accessed/called from an excel vba (by
first referencing the tlb file).

My excel vba is as follows:

Private moTemp As mydll.IDemo
 
Sub trial()
moTemp.doSomething
End Sub

Excel VBA seems to recognize class and subfunction as I'm typing them,
but when I run the "trial" macro I get the following error:

"Run-time error '91': Object variable or With block variable not set"

Have I done everything I need to in vb, and if so does anyone know if the call from excel vba is correct?

Thanks in advance,

[Curtis Rutland]

Please use [code] tags (the # button on the text editor) when posting in this forum.

Please read the Posting Guidelines

MODERATOR

[Spence5]

I may have possibly posted this in the wrong forum (judging from the fact that nobody seems to have any knowledge in this area). I'll try elsewhere.

Thanks anyways,