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 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
| Function first_day_last_week() As Date
Dim j As Integer
j = WeekDay(Date, vbMonday)
first_day_last_week = DateAdd("d", 1 - j - 7, Date)
End Function
' et le test
Function test()
Dim Chemin As String
Dim Rs As DAO.Recordset
Dim Excl As Object
Dim Sql As String
On Error GoTo Test_Err
'Chemin = "c:\test.xls"
Chemin = ""
Sql = "select * from tatable where [tadate] between #" & Format(first_day_last_week, "mm/dd/yyyy") & "# and #" & Format(first_day_last_week + 6, "mm/dd/yyyy") & "#" & _
" order by date;"
Set Rs = CurrentDb.OpenRecordset(Sql, dbOpenSnapshot)
Set Excl = fExportExcel(Chemin, Rs, True, 2, 1)
If Excl.Name <> "" Then
'Autres manipulation du classeur
Excl.Application.Visible = True
Excl.Cells(1, 1) = "titre du document"
Excl.SaveAs "c:\test_bis.xls"
Excl.Application.Quit
Set Excl = Nothing
End If
Exit Function
Test_Err:
If Err.Number <> 91 Then
MsgBox "Une erreur inattendue est apparue dans la fonction Test. L'erreur N° " & Err.Number & " ( " & Err.Description & " )! Contactez l'administrateur.", vbOKOnly + vbCritical, "Erreur inattendue !"
End If
Set Excl = Nothing
Set Rs = Nothing
End Function |
Partager