|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
eyeshen 发表于 2011-10-25 17:32
很好,能运行。就是有些怕这句话 [Excel 8.0;Database=" & ThisWorkbook.FullName & "].[Sheet1$],每次 ...
当然可以,请参考:
- Sub Macro2()
- Dim cnn As Object
- Dim arr, i&
- arr = [a1].CurrentRegion
- Set cnn = CreateObject("adodb.connection")
- cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & ThisWorkbook.Path & "\db.mdb"
- For i = 2 To UBound(arr)
- If arr(i, 5) = "取消" Then cnn.Execute "update 考试情况 set 分数=0,缺考='是' where 编号=" & arr(i, 1)
- Next
- cnn.Close
- Set cnn = Nothing
- End Sub
复制代码
|
|