1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| Private Sub Commande3_Click()
If Dir("d:\BaseAccess.xls") <> "" Then
Kill ("d:\BaseAccess.xls")
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Banque", "d:\BaseAccess.xls", True
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Bureau de poste", "d:\BaseAccess.xls", True
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Encaissements", "d:\BaseAccess.xls", True
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Encaissements Cheques", "d:\BaseAccess.xls", True
MsgBox "Fichier enregistré"
DoCmd.Quit
Else
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Banque", "d:\BaseAccess.xls", True
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Bureau de poste", "d:\BaseAccess.xls", True
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Encaissements", "d:\BaseAccess.xls", True
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Encaissements Cheques", "d:\BaseAccess.xls", True
MsgBox "Fichier enregistré"
DoCmd.Quit
End If
End Sub |
Partager