create dll files in vb

[janamca]

Hi all of you,
i join new in this group. i want detail about how to create and use dll files in vb. Please send code thank you
Your's
Jana

[sukeshchand]

open new vb project and select Activex dll,
and add one class module , write function to it.
if you want to access the function written inside the dll you must be declare as public function
then you can make dll by using file make dll
and after creating new dll you can add this dll to another vb project by using add refference and browse the dll file. and call the dll by using projectname.class name like this dim dll1 as new Dllproject.sclass
and you can call the function like this dll.getfield

ex::

dll source code
'This function is used to get a field from database
'This code must be in dll project and add this in a class called SClass and the project name is sukesh
Public Function GetField(ByRef conn As ADODB.Connection, ByVal StrSql As String) As Variant
On Error GoTo ErrHr
With conn.Execute(StrSql)
If Not .EOF Then
GetField = .Fields(0) & ""
End If
.Close
End With
Exit Function
ErrHr:
End Function

'In the Vb program we can call this dll by like this
'First add this dll to reference
private command1_click()
dim dll1 as new sukesh.sclass
msgbox dll1.GetField(conn,"Select Name from Student where id=90")
end sub

sukesh