Option Explicit
Sub Archiver()
Dim wk1 As Workbook, CC As Workbook
Dim wk2 As String, chemin As String, extension As String, Pays As String
Dim i As Integer, n As Integer
Dim lks As Variant
Application.DisplayAlerts = False
chemin = ThisWorkbook.Path & "\"
Set wk1 = ThisWorkbook
wk2 = "Pays test macro.xlsx"
extension = ".xlsx"
Application.ScreenUpdating = False
For n = 4 To 6 'adapter à la plage de cellules Nom de pays
Pays = wk1.Sheets("Feuil1").Range("A" & n) 'adapter à la plage de cellules Nom de pays
If Pays <> "" Then
Workbooks(wk2).Sheets("E2258_1").Range("A6") = Pays
Workbooks(wk2).SaveAs Filename:=chemin & "Test_" & Pays & extension, FileFormat:=51
Set CC = Workbooks("Test_" & Pays & extension)
On Error Resume Next
CC.ActiveSheet.DrawingObjects(1).Delete
On Error GoTo 0
lks = CC.LinkSources(1)
If Not IsEmpty(lks) Then
For i = 1 To UBound(lks)
CC.BreakLink Name:=lks(i), Type:=xlExcelLinks
Next i
End If
CC.Close SaveChanges:=True
Workbooks.Open chemin & wk2
End If
Next n
Application.ScreenUpdating = True
Application.DisplayAlerts = False
Dim sc = Sheets.Count
For i = sc - 1 To sc
With Sheets(i)
.Columns("A:B").Delete shift:=xlToLeft
End With
Next i
End Sub
Désolée je suis vraiment débutante
J'ai essayé Dim sc As Sheets.Count mais ça ne marche pas