dll

Hi,
I would like to call a com component (i.e a dll which is created in .net) from another program i.e. an excel VBA.

How is it possible to create a dll in .net?
Thanks

File> New Project

Select Visual Basic, then The DLL....

Hi,
But my question is how to create the dll in vb.net so that I can reference this created .dll in excel?
Thanks

You can create a DLL like I said. To reference 1, well I'm not sure exactly how, but I think you may have to declare everything in each function like this is references a DLL to use the INI write capability

VB Code:

<DllImport("kernel32.dll")> _
        Private Overloads Shared Function WritePrivateProfileString( _
        ByVal lpApplicationName As String, _
        ByVal lpKeyName As String, _
        ByVal lpString As String, _
        ByVal lpFileName As String) As Integer
    End Function

Maybe you can work your way off that? Can't really help much more, maybe someone else will come along..

http://www.vbforums.com/showthread.p...hreadid=258232