1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| Private Sub Commande0_Click()
On Error GoTo Err_Commande0_Click
Dim sql As String
Dim qd As QueryDef
sql = "SELECT * FROM T_TOTAL Where "
sql = sql & "T_TOTAL.U_Chrono = " & Me.cmbRechNom & " ;"
Set qd = CurrentDb.CreateQueryDef("U_Chrono", sql)
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "U_Chrono", "u:\test_bd\traitement.xls"
DoCmd.DeleteObject acQuery, "U_Chrono"
Set oApp = CreateObject("Excel.Application")
oApp.Visible = True
'Only XL 97 supports UserControl Property
On Error Resume Next
oApp.UserControl = True
Exit_Commande0_Click:
Exit Sub
Err_Commande0_Click:
On Error Resume Next
DoCmd.DeleteObject acQuery, "U_Chrono"
'DoCmd.DeleteObject acQuery, "T_TOTAL"
MsgBox Err.Description
Resume Exit_Commande0_Click
End Sub |
Partager