VBA - how to exit excel? 1

[Rigger123]

Hi, im new to VBA and i was wondering if anyone could tell me the code for exiting excel. so far ive been using | Application.Quit | but i then get the dialog box "do you want to save changes to excel" (which i want to say no to) but have had no luck so far at avoiding this. any help greatly appreciated.

 

[Adnane]

Have you tried putting in the beginning of the code Application.DisplayAlerts = False


Adnane

Micorosft North Africa

http://www.microsoft.com/northafrica

 

[Rigger123]

Adnane This was exactly what i wanted, have a star.

He who smiles in a crisis has found someone to blame.

 

[jajinder]

Another solution:

Private Sub ThisWorkBook_BeforeClose(Cancel As Boolean)
ThisWorkBook.Saved = True
End Sub

Greets Jajinder