如果DataGrid是与记录集rs绑定的,可以这样: Public Sub Export(rs As Recordset, datagridName As Object) Dim xlApp As Object 'Excel.Application Dim xlBook As Object 'Excel.Workbook Dim xlSheet As Object 'Excel.Worksheet Screen.MousePointer = vbHourglass On Error GoTo Err_Proc Set xlApp = CreateObject("Excel.Application") Set xlBook = xlApp.Workbooks.Add Set xlSheet = xlBook.Worksheets(1) 'Begin to fill data to sheet Dim i As Long Dim j As Integer With datagridName For i = 0 To rs.RecordCount - 1 .Row = i For j = 0 To rs.Fields.Count - 1 .Col = j xlSheet.cells(i + 1, j + 1).Value = "'" & datagridName.Text Next j Next i End With xlApp.Visible = True Screen.MousePointer = vbDefault Exit Sub Err_Proc: Screen.MousePointer = vbDefault MsgBox "请确认是否已安装Excel!", vbExclamation, "提示"
Public Sub Export(rs As Recordset, datagridName As Object)
Dim xlApp As Object 'Excel.Application
Dim xlBook As Object 'Excel.Workbook
Dim xlSheet As Object 'Excel.Worksheet Screen.MousePointer = vbHourglass
On Error GoTo Err_Proc
Set xlApp = CreateObject("Excel.Application")
Set xlBook = xlApp.Workbooks.Add
Set xlSheet = xlBook.Worksheets(1) 'Begin to fill data to sheet
Dim i As Long
Dim j As Integer
With datagridName
For i = 0 To rs.RecordCount - 1
.Row = i
For j = 0 To rs.Fields.Count - 1
.Col = j
xlSheet.cells(i + 1, j + 1).Value = "'" & datagridName.Text
Next j
Next i
End With
xlApp.Visible = True
Screen.MousePointer = vbDefault
Exit Sub
Err_Proc:
Screen.MousePointer = vbDefault
MsgBox "请确认是否已安装Excel!", vbExclamation, "提示"
End Sub