Execl中VBA的问题,有源码,高分!
Private Sub Workbook_Open()
Dim i As Integer
Dim j As Integer
Set cnn = CreateObject("ADODB.connection")
Set rs = CreateObject("ADODB.Recordset")
cnn.connectionstring = "Driver={SQL Server};server=128.129.36.64;uid=sa;pwd=;database=ycjxc"
cnn.Open
Sheet2.Cells(1, 1) = "代码"
Sheet2.Cells(1, 2) = "名称"
Sheet2.Cells(1, 3) = "数量"
Sheet2.Cells(1, 4) = "金额"
Sheet2.Cells(1, 5) = "单价"
Set rs = cnn.Execute("select sum(sl),sum(je) from xs200206 " & " where shr='邹仁钧'or shr='赵波'or shr='丁德权'or shr='杨键' or shr='周勇'or shr='从红奎' or shr='朱建国'or shr='王春山'")
Sheet2.Cells(2, 1) = "合计"
Sheet2.Cells(2, 3) = rs(0).Value
Sheet2.Cells(2, 4) = rs(1).Value
Set rs = cnn.Execute("Select jydm,jymc,sum(sl),sum(je),dj from xs200206 " & "where shr='邹仁钧'or shr='赵波'or shr='丁德权'or shr='杨键' or shr='周勇'or shr='从红奎' or shr='朱建国'or shr='王春山' " & "group by jydm,jymc,dj " & " order by dj desc ")
rs.movefirst
i = 3
j = 0
While Not rs.EOF
Sheet2.Cells(i, 1) = rs(0).Value
Sheet2.Cells(i, 2) = rs(1).Value
Sheet2.Cells(i, 3) = rs(2).Value
Sheet2.Cells(i, 4) = rs(3).Value
Sheet2.Cells(i, 5) = rs(4).Value
i = i + 1
rs.movenext
Wend
cnn.Close
Set cnn = Nothing
Set rs = Nothing
End Sub
以上是我的源码,已经通过运行。现在要在这个基础上进一步分类。就是jydm中有一些是以32******开头的,而有一些不是,我要把这两个分开,要如何才能实现,在数据库中或在Sheet2中实现都行,最好是在Sheet2中实行。谢谢!!!