'Import Commande
Private Sub CommandButton1_Click()
Dim Tablo, Tablo2
Application.ScreenUpdating = False
On Error GoTo fin
If [J12] = "" Or [L12] = "" Then
MsgBox ("Veuillez renseigner le client ou la date")
Exit Sub
End If
onglet = [L12]
Workbooks.Open ("C:\Users\XXXXXXXXXXX.xlsx")
With Sheets(onglet)
Tablo = .Range("C14:G50")
Tablo2 = .Range("E4:H10")
End With
ActiveWorkbook.Close False
' Classeur et Feuille dans lesquels il faut importer et coller les données
With ActiveSheet
.Range("C14").Resize(UBound(Tablo, 1), UBound(Tablo, 2)) = Tablo
.Range("E4").Resize(UBound(Tablo2, 1), UBound(Tablo2, 2)) = Tablo2
.Range("B1").Select
End With
'Range("F20:F60").Formula = _
"=IF(RC[-3]="""","""",VLOOKUP(RC[-3],'Commandes Clients'!R10C1:R1000C4,4,0))"
'Range("H20:H60").Formula = _
"=IF(OR(RC[-3]="""",RC[-2]=""""),"""",RC[-2]*RC[-3])"
Exit Sub
fin: MsgBox ("Onglet Introuvable")
ActiveWorkbook.Close False
ActiveSheet.[B1].Select
Exit Sub
End Sub