Private Sub Workbook_Open()
'每当workbook打开时,就判断excel数据库是否为空
Dim conn, rst As Object
Dim sql As String
Set conn = CreateObject("adodb.connection")
Set rst = CreateObject("adodb.recordset")
conn.Open "provider=microsoft.ACE.OLEDB.12.0;extended properties=excel 12.0;data source=" & ThisWorkbook.Path & "\数据库.xlsx"