Dim rstmember As ADODB.Recordset
If Text1.Text = "" Or Text2.Text = "" Then
MsgBox "请将信息填写完整", vbOKOnly + vbExclamation, "警告"
Exit Sub
End If
'添加新记录
sqlstr = "select * from sheet1$"
Set rstmember = ExecuteSQL(sqlstr, msgtext)
rstmember.AddNew
提示的错误语句是:Set rstmember = ExecuteSQL(sqlstr, msgtext)