在Excel里面,vba调用存储过程,返回结果集,报错
tedy 2011-10-24 02:20:30 Dim rs As New ADODB.Recordset
Dim cmd As New ADODB.Command
cmd.CommandText = "sp_test"
cmd.CommandType = adCmdStoredProc
cmd.CommandTimeout = 30
...
Set rs = cmd.Execute()
i = rs.RecordCount
...
报错:
当物件关闭时,不允许操作