Private Sub Command1_Click()
Dim ExcelID As Excel.Application
Set ExcelID = New Excel.Application
ExcelID.Visible = True
ExcelID.Workbooks.Add
ExcelID.Workbooks.Open ("D:\yang.xls")
ExcelID.Worksheets(1).Activate
Dim rs As New ADODB.Recordset
rs.Open "select * from 工资表 where 所属工资月份=(select 月份 from 月份表) order by 班组名称,工号", Cnn, adOpenKeyset, adLockOptimistic
Dim i As Integer, r As Integer, c As Integer
For i = 0 To rs.Fields.Count - 1
ExcelID.Cells(2, i + 1) = rs.Fields(i).Name
Next i
rs.MoveFirst
Do Until rs.EOF
r = rs.AbsolutePosition
For c = 0 To rs.RecordCount - 1
Worksheets(1).Cells(r + 4, c + 1) = rs.Fields(c) 代码执行到这里只是在一行里从第一条记录读到最后一条,
我想做到都在excel中全都显示出来
Next c
rs.MoveNext
Loop
'ExcelID.Worksheets(1).Rows(8).PageBreak = 1
End Sub
Dim ExcelID As Excel.Application
Set ExcelID = New Excel.Application
ExcelID.Visible = True
ExcelID.Workbooks.Add
ExcelID.Workbooks.Open ("D:\yang.xls")
ExcelID.Worksheets(1).Activate
Dim rs As New ADODB.Recordset
rs.Open "select * from 工资表 where 所属工资月份=(select 月份 from 月份表) order by 班组名称,工号", Cnn, adOpenKeyset, adLockOptimistic
Dim i As Integer, r As Integer, c As Integer
For i = 0 To rs.Fields.Count - 1
ExcelID.Cells(2, i + 1) = rs.Fields(i).Name
Next i
rs.MoveFirst
Do Until rs.EOF
r = rs.AbsolutePosition
For c = 0 To rs.RecordCount - 1
Worksheets(1).Cells(r + 4, c + 1) = rs.Fields(c) 代码执行到这里只是在一行里从第一条记录读到最后一条,
我想做到都在excel中全都显示出来
Next c
rs.MoveNext
Loop
'ExcelID.Worksheets(1).Rows(8).PageBreak = 1
End Sub
解决方案 »
- 关于RePlace的疑问
- 现在有一个java写好的加密算法,要改成vb的,有什么好办法么
- VB中adodc的查询问题
- 程序编译不成功
- 问一个问题,请高手指教!
- 刻到光盘上的安装程序,安装到硬盘上后,access数据库是否变成了只读?
- 如何调用当前路径的DLL,而不是调用系统文件夹里的DLL。
- 在线等待,急急急,记录筛选
- 用VB6能不能查到Cpu或硬盘的ID号?
- 如何让一个SSTAB的三个TAB分别成为三个LABEL控件数组的容器?请各位高手指点,我能给这点分了。
- 东莞的三大创举,治摩,禁猪,禁人(转帖,看看这个伟大的刘大书记.....)
- vb6 datagrid新增一行时,报错:无法将null值......
r = 0
Do Until rs.EOF
r = rs.AbsolutePosition
For c = 0 To rs.RecordCount - 1
Worksheets(1).Cells(r + 4, c + 1) = rs.Fields(c)
Next c
r =r +1
rs.MoveNext
Loop
rs.MoveFirst
r = 0
Do Until rs.EOF
'r = rs.AbsolutePosition
For c = 0 To rs.RecordCount - 1
Worksheets(1).Cells(r + 4, c + 1) = rs.Fields(c)
Next c
r =r +1
rs.MoveNext
Loop