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
| Private Sub Commande8_Click()
Dim qd As QueryDef
Dim SQLENREGISTREMENT As String
SQLENREGISTREMENT = "SELECT Hsupp.n°, Hsupp.NomSalarié, Hsupp.PrenomSalarié, Hsupp.Jours,Hsupp.Mois, Hsupp.HSJourJoursOuvrables, Hsupp.HSJourDimanchesetFetes, Hsupp.HSNuit, Hsupp.TrancheshorairesHSJoursOuvrables, Hsupp.TrancheshorairesHSDimanchesetFetes, Hsupp.TranchesHorairesHSNuit, Hsupp.Motif FROM Hsupp WHERE Hsupp.ServiceSalarié ='" & ServiceSalariéActuel & "' And Hsupp.Mois='" & moisactuel & "' And Hsupp.Année ='" & anneeactuel & "';"
Set qd = CurrentDb.CreateQueryDef("tempo", SQLENREGISTREMENT)
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tempo", "C:\Users\stage-info\Desktop\Stage FLORY Lucas\Feuille.xlsx"
Dim xlApp As Object
Dim xlBook As Object
'ouverture/modification du fichier
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
Set xlBook = xlApp.Workbooks.Open("C:\Users\stage-info\Desktop\Stage FLORY Lucas\Feuille.xls")
'enregistrment
xlBook.Save
'fermeture du classeur
xlBook.Close False
'fermeture excel
xlApp.Quit
Set xlApp = Nothing
Set xlBook = Nothing
DoCmd.DeleteObject acQuery, "tempo"
Set qd = Nothing
End Sub |
Partager