Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionOn Error GoTo Err_Commande11_Click
On Error GoTo Err_Commande11_Click
Private Sub Commande11_Click() 'On Error GoTo Err_Commande11_Click Dim Chemin Dim oApp As Object Dim oWKB As Object Dim oSHT As Object Chemin = InputBox("Entrer le chemin d'enregistrement des données", , "C:\My Documents") DoCmd.TransferSpreadsheet acExport, 8, "Leçons par projet", Chemin, False, "" Set oApp = CreateObject("Excel.Application") Chemin = Chemin & ".xls" Set oWKB = oApp.Workbooks.Open(Filename:=Chemin) oApp.Application.Visible = True Set oSHT = oApp.Application.Worksheets("Leçons_par_projet") With oSHT .Activate With .PageSetup .CenterHeader = "" .CenterFooter = "" .Orientation = xlLandscape End With .Columns("C:C").Delete Shift:=xlToLeft .Columns("I:I").Delete Shift:=xlToLeft .Columns("A:H").Select Selection.HorizontalAlignment = xlGeneral Selection.VerticalAlignment = xlTop Selection.WrapText = True Selection.Orientation = 0 Selection.ShrinkToFit = True Selection.Font.name = "Arial" Selection.Font.Size = 9 End With oApp.Quit Set oApp = Nothing Set Chemin = Nothing 'Exit_Commande11_Click: ' On Error Resume Next ' oWKB.Save ' oWKB.Close ' oApp.Quit ' Set oApp = Nothing ' Set oWKB = Nothing ' Set oSHT = Nothing ' Exit Sub 'Err_Commande11_Click: ' MsgBox Err.Description ' Resume Exit_Commande11_Click End Sub
Selection.HorizontalAlignment = xlGeneral
oSHT.Selection.HorizontalAlignment = xlGeneral