|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub dsmch()
- Set cn = CreateObject("ADODB.Connection")
- Sheet2.Activate
- arr = Range("a1").CurrentRegion
- cn.Open "Provider =Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;Data Source=" & ThisWorkbook.FullName
- For i = 2 To UBound(arr)
- Sql = "select count(姓名) from [数据表$] where 数学>=" & arr(i, 1) & " and 数学<=" & arr(i, 2) & "and 语文>=" & arr(i, 3) & " and 语文<=" & arr(i, 4) & "and 英语>=" & arr(i, 5) & " and 英语<=" & arr(i, 6)
- Cells(i, "g") = cn.Execute(Sql)(0)
- Next
- End Sub
复制代码 |
|