I have Excel 2002 on Win XP. How can I close Excel with a macro.? In Access
I use a macro with Quit in it, this closes the database as well as Access.
Is there an equivalent in excel which will close the workbook and then Excel
itself ?



Thanks . Roger

application.quit

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Roger Ottaway" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have Excel 2002 on Win XP. How can I close Excel with a macro.? In
Access
> I use a macro with Quit in it, this closes the database as well as Access.
> Is there an equivalent in excel which will close the workbook and then
Excel
> itself ?
>
>
>
> Thanks . Roger
>
>

Roger

Use this to close the workbook without saving

ThisWorkbook.Saved = True
Application.Quit

And this if you want to save it first

ThisWorkbook.Save
Application.Quit

If you want to suppress warnings preface wrap the code with

Application.DisplayAlerts = False

Gord Dibben XL2002


On Sun, 23 Nov 2003 16:35:06 +0100, "Roger Ottaway" <(E-Mail Removed)>
wrote:

>I have Excel 2002 on Win XP. How can I close Excel with a macro.? In Access
>I use a macro with Quit in it, this closes the database as well as Access.
>Is there an equivalent in excel which will close the workbook and then Excel
>itself ?
>
>
>
>Thanks . Roger
>