集合与用户自定义数据类型问题
Public Type emptype
em_id As String
em_name As String
End Type
Dim employees As New Collection
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Public Sub openTable()
Dim employee As emptype
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.ConnectionString = "provider=sqloledb.1;data source=.;user id=sa;password=lide;initial catalog=northwind"
conn.Open
rs.Open "employees", conn, adOpenKeyset, adLockPessimistic
For i = 1 To rs.RecordCount
employee.em_id = rs.Fields(0)
employee.em_name = rs.Fields(1)
employees.Add employee, employee.em_id
rs.MoveNext
Next
End Sub
上面报错为“只有在公共模块中用户自定义数据类型才可以与变体类型转换”不过,我放在公共模块中仍不行,为什么?怎么做?