|
tonygz83 发表于 2013-10-13 00:25
报错:用户定义类型未定义。何解呢??
使用了前期绑定,需要引用Microsoft ActiveX Data Objects 2.x Library
来一个后期绑定,不需要引用:- Private Sub Workbook_Open()
- Dim cnn As Object
- Dim SQL As String
- Set cnn = CreateObject("ADODB.Connection")
- cnn.Open "provider=microsoft.Ace.oledb.12.0;extended properties=excel 12.0;data source=" & ThisWorkbook.Path & "\记录\记录.xlsx"
- SQL = "insert into [Sheet1$] (用户名,计算机名,文件打开时间) values ('" & Environ("username") & "','" & Environ("ComputerName") & "',#" & Now & "#)"
- cnn.Execute SQL
- cnn.Close
- Set cnn = Nothing
- End Sub
复制代码 |
|