Sub Traitement()
Sheets("Data").Select
semaine = Cells(4, 18)
If semaine = 1 Then
smoinsun = 52
Else
smoinsun = semaine - 1
End If
'MAJ des données de la dernière ligne avant delete
Sheets("Data").Select
Range("D17:L17").Select
Selection.Replace What:="S" & smoinsun - 9 & "", Replacement:="S" & smoinsun - 8 & "", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
'Delete des anciennes feuille
Sheets("S" & smoinsun - 9).Select
ActiveWindow.SelectedSheets.Delete
Sheets("VS" & smoinsun - 9).Select
ActiveWindow.SelectedSheets.Delete
'Copie SA021
Sheets("Data").Select
dossier_gadd = Cells(4, 23)
Workbooks.Open(Filename:= _
"" & dossier_gadd & "\SA021.xls" _
).RunAutoMacros Which:=xlAutoOpen
Sheets("Data").Select
Sheets("Data").Name = "Data"
Cells.Select
Selection.Copy
Windows("Historique SRS.xls").Activate
Sheets("VS" & semaine).Select
Sheets("VS" & semaine).Range("A1").Select
ActiveSheet.Paste
Workbooks("SA021.xls").Activate
Sheets("Data").Range("A1").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = ""
Sheets("Data").Range("A1").Select
ActiveWorkbook.Saved = True
ActiveWorkbook.Close
'Copie SR021
Sheets("Data").Select
dossier_gadd = Cells(4, 23)
Workbooks.Open(Filename:= _
"" & dossier_gadd & "\SR021.xls" _
).RunAutoMacros Which:=xlAutoOpen
Sheets("Data").Select
Sheets("Data").Name = "Data"
Cells.Select
Selection.Copy
Windows("Historique SRS.xls").Activate
Sheets("S" & semaine).Select
Sheets("S" & semaine).Range("A1").Select
ActiveSheet.Paste
Workbooks("SR021.xls").Activate
Sheets("Data").Range("A1").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = ""
Sheets("Data").Range("A1").Select
ActiveWorkbook.Saved = True
ActiveWorkbook.Close
Sheets("Data").Select
'MAJ des données
Range("B8").Select
Selection.Replace What:="S" & smoinsun - 1 & "", Replacement:="S" & smoinsun & "", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("D8:L8").Select
Selection.Replace What:="S" & smoinsun & "", Replacement:="S" & semaine & "", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("B9").Select
Selection.Replace What:="S" & smoinsun - 2 & "", Replacement:="S" & smoinsun - 1 & "", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("D9:L9").Select
Selection.Replace What:="S" & smoinsun - 1 & "", Replacement:="S" & smoinsun & "", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("B10").Select
Selection.Replace What:="S" & smoinsun - 3 & "", Replacement:="S" & smoinsun - 2 & "", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("D10:L10").Select
Selection.Replace What:="S" & smoinsun - 2 & "", Replacement:="S" & smoinsun - 1 & "", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("B11").Select
Selection.Replace What:="S" & smoinsun - 4 & "", Replacement:="S" & smoinsun - 3 & "", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("D11:L11").Select
Selection.Replace What:="S" & smoinsun - 3 & "", Replacement:="S" & smoinsun - 2 & "", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("B12").Select
Selection.Replace What:="S" & smoinsun - 5 & "", Replacement:="S" & smoinsun - 4 & "", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("D12:L12").Select
Selection.Replace What:="S" & smoinsun - 4 & "", Replacement:="S" & smoinsun - 3 & "", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("B13").Select
Selection.Replace What:="S" & smoinsun - 6 & "", Replacement:="S" & smoinsun - 5 & "", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("D13:L13").Select
Selection.Replace What:="S" & smoinsun - 5 & "", Replacement:="S" & smoinsun - 4 & "", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("B14").Select
Selection.Replace What:="S" & smoinsun - 7 & "", Replacement:="S" & smoinsun - 6 & "", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("D14:L14").Select
Selection.Replace What:="S" & smoinsun - 6 & "", Replacement:="S" & smoinsun - 5 & "", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("B15").Select
Selection.Replace What:="S" & smoinsun - 8 & "", Replacement:="S" & smoinsun - 7 & "", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("D15:L15").Select
Selection.Replace What:="S" & smoinsun - 7 & "", Replacement:="S" & smoinsun - 6 & "", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("B16").Select
Selection.Replace What:="S" & smoinsun - 9 & "", Replacement:="S" & smoinsun - 8 & "", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("D16:L16").Select
Selection.Replace What:="S" & smoinsun - 8 & "", Replacement:="S" & smoinsun - 7 & "", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
'On sauvegarde et on ferme
Windows("Historique SRS.xls").Activate
Sheets("Data").Select
Sheets("Data").Range("B4").Select
ActiveWorkbook.Save
ActiveWindow.Close
End Sub