I made a .DLL useing VB 2010 Express and want to call it in Excel VBA.
Here is my DLL code
PublicFunction MPSIDNum(ByVal LookupType AsLong, ByVal MPSValue AsString)
Dim oConnection As ADODB.Connection
Dim oRecordset As ADOR.Recordset
Dim FieldCol AsString
FieldCol = SetField(LookupType)...