Solved: Close Excel?

[Mr.G]

What is the code to close Excel ,or can't one close excel with code? I can close the workbook but would like to close the program.
Here is my code for a book.......[VBA]ActiveWorkbook.Close ("WB name..xls")[/VBA]
Any help please.

[Simon Lloyd]

Hi its
[VBA]
Application.Quit
[/VBA]I think!

Regards,
Simon

[Mr.G]

Thanx but that only closes the workbook not excel.

[Simon Lloyd]

The below is from here http://www.contextures.com/xlfaqMac.html#Close

How do I close a file/close Excel with a macro?

ActiveWorkbook.Close savechanges:=False 'true ??? --will close the active workbook Workbooks("mywkbk.xls").Close savechanges:=False 'true ??? --will close mywkbk.xls ThisWorkbook.Close savechanges:=False 'true ??? --will close the workbook that holds the code that's running. Application.Quit will close all of Excel. --Be careful with this one.

Regards,

SImon

[Mr.G]

A ha..... just had put it in the right place
Thanx Simon.

[lucas]

[VBA]Private Sub CommandButton1_Click()
Application.DisplayAlerts = False
Application.Quit
End Sub[/VBA]
I use this. As Simon points out be careful as it closes without saving changes.

[Mr.G]

Thanx all