closing excel at the end of a macro

[jimmywanna]

Hello all,

I have made a series of workbooks that print labels and worksheets for chemotherapy drugs. It's working very well but could be slightly better. The end of the macro reads:

ActiveWorkbook.Close SaveChanges:=False

Is it possible for the macro to close Excel and not just the workbook?

Thanks in advance

Jamie

 

[VoG]

Try

Application.Quit

 

[jimmywanna]

Thanks for your reply, it didn't seem to like that. I also tried Application.Close. any other ides?

Thanks again

 

[VoG]

From the Help

Quit Method


Quits Microsoft Excel.
Syntax
expression.Quit
expression Required. An expression that returns an Application object.
Remarks
If unsaved workbooks are open when you use this method, Microsoft Excel displays a dialog box asking whether you want to save the changes. You can prevent this by saving all workbooks before using the Quit method or by setting the DisplayAlerts property to False. When this property is False, Microsoft Excel doesn’t display the dialog box when you quit with unsaved workbooks; it quits without saving them.
If you set the Saved property for a workbook to True without saving the workbook to the disk, Microsoft Excel will quit without asking you to save the workbook.

 

[Sektor]

Try to set Application.DisplayAlerts = False before Application.Quit.

 

[jimmywanna]

Brilliant.

Thank you very much.

Jamie