Private Sub Command1_Click()
Dim i As Long, j As Long, zsl As Long
' Dim xlsApp As Excel.Application
' Dim xlswb As Excel.Workbook
' Dim xlsws As Excel.Worksheet
Set xlsApp = CreateObject("Excel.Application")
xlsApp.Visible = False '调试时设为True
Set xlswb = xlsApp.Workbooks.Add
Set xlsws = xlswb.Worksheets(1)
Adodc1.Recordset.MoveFirst
Adodc1.Recordset.MoveLast
zsl = Adodc1.Recordset.RecordCount
Adodc1.Recordset.MoveFirst
i = 1
Do While Not Adodc1.Recordset.EOF
For j = 1 To Adodc1.Recordset.Fields.Count
If Not IsNull(DataGrid1.Text) Then
xlsws.Cells(i, j) = Adodc1.Recordset(j - 1)
End If
Next
Adodc1.Recordset.MoveNext
i = i + 1
Loop
xlswb.SaveAs App.Path & "\GetFromDataGrid.xls"
xlsApp.Quit
End Sub
Dim i As Long, j As Long, zsl As Long
' Dim xlsApp As Excel.Application
' Dim xlswb As Excel.Workbook
' Dim xlsws As Excel.Worksheet
Set xlsApp = CreateObject("Excel.Application")
xlsApp.Visible = False '调试时设为True
Set xlswb = xlsApp.Workbooks.Add
Set xlsws = xlswb.Worksheets(1)
Adodc1.Recordset.MoveFirst
Adodc1.Recordset.MoveLast
zsl = Adodc1.Recordset.RecordCount
Adodc1.Recordset.MoveFirst
i = 1
Do While Not Adodc1.Recordset.EOF
For j = 1 To Adodc1.Recordset.Fields.Count
If Not IsNull(DataGrid1.Text) Then
xlsws.Cells(i, j) = Adodc1.Recordset(j - 1)
End If
Next
Adodc1.Recordset.MoveNext
i = i + 1
Loop
xlswb.SaveAs App.Path & "\GetFromDataGrid.xls"
xlsApp.Quit
End Sub
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货