Application Excel de fermeture en utilisant VBA

Mots clés : excelvbaexcel-2007excel

meilleur 5 Réponses Application Excel de fermeture en utilisant VBA

vote vote

91

ThisWorkbook.Saved = True 
Application.Quit 
vote vote

83

Application.DisplayAlerts = False ThisWorkbook.Save Application.DisplayAlerts = True 
Application.Quit 
Sub testSave() Application.DisplayAlerts = False ThisWorkbook.Save Application.DisplayAlerts = True Application.Quit End Sub 
vote vote

74

Sub TestSave() Application.Quit ThisWorkBook.Close SaveChanges = False End Sub 
vote vote

64

Application.Quit  
vote vote

57

ThisWorkbook.Saved = True Application.Quit Application.ActiveWindow.Close SaveChanges:=False ActiveWorkbook.Close SaveChanges:=False 

Questions similaires