Excel Macros

[Dealer]

PLease i need help. I need to find code to put into a macro that will exit out of Excel when clicked/run. Can anyone polease help. i want basic code, nothing too complicated. Ive tried End, Exit, non of these work. PLease reply, i have to find a soloutio within 24 hours or im roasted.

Shmail

 

[JVFriederick]

All I know is how to close the active workbook :

ThisWorkbook.Saved = True
ActiveWorkbook.Close (False)

I do not know how to exit Excel from a macro, sorry.

 

[JVFriederick]

Looky what I found :


ThisWorkbook.Saved = True
Application.Quit

 

[Store300]

The danger here is that it will shutdown excel without saving the active workbook. To avoid this you could use:

ActiveWorkbook.Save or Workbooks("MyWorkbookName.xls&quot.Save
Application.Quit