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
|
Sub copie_xls_vers_ppt(WB, PptPres, List_onglet As Variant)
' Activation de la gestion des erreurs
On Error GoTo ErrorMessage
Dim n As Integer, i As Integer, k As Integer, c As Interior
' =======================================
' pour les onglets sélectionnés du classeur
n = UBound(List_onglet, 1)
For k = n To 1 Step -1
i = List_onglet(k)
PptPres.Activate
PptPres.Sheets.Add before:=Worksheets(Worksheets.Count)
WB.Activate
WB.Worksheets(i).Activate
ActiveSheet.Range(ActiveSheet.PageSetup.PrintArea).Copy
PptPres.Activate
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteColumnWidths, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
WB.Worksheets(i).Copy before:=PptPres.Worksheets(1)
Next k
WB.Close False
Exit Sub
'********************* Gestion des erreurs *************************
ErrorMessage:
'Erreur lors de l'éxécution
msg = MsgBox("L'erreur # " & Str(Err.Number) & " a été générée par " _
& Err.Source & Chr(13) & Err.Description, vbCritical + vbOKOnly, "Erreur Identification")
End Sub |
Partager