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
| Sub Macro1()
Dim Chemin As String, Frecent As String, Fprecedent As String
Dim Name As String, NamePrec As String, Year As Integer, Week As Long
Year = Format(Date, "yyyy") ' Année
Week = Format(Date, "ww") ' N° Semaine
Name = "Real" & Year & Week ' Nom du fichier
NamePrec = "Real" & Year & Week - 1
Chemin = "Q:\AR3\Données EXCEL\"
Frecent = Chemin & Name & ".xls"
Fprecedent = Chemin & NamePrec & ".xls"
' MsgBox Frecent, vbOKOnly, "Fichier semaine en cours"
' Select Case MsgBox(Fprecedent, vbOKCancel, "Fichier semaine précédente")
' Case vbCancel
' Exit Sub
' Case vbOK
If FileExiste(Frecent) Then
Workbooks.Open (Frecent)
Else
If FileExistePrec(Fprecedent) Then
Workbooks.Open (Fprecedent)
Else
MsgBox "Fichier inexistant", vbOKOnly, "Fichier non trouvé"
End If
End If
End Select
End Sub
Function FileExiste(Frecent As String) As Boolean
FileExiste = Dir(Frecent) <> "" And Frecent <> ""
End Function
Function FileExistePrec(Fprecedent As String) As Boolean
FileExistePrec = Dir(Fprecedent) <> "" And Fprecedent <> ""
End Function |
Partager