Macro Code for closing excel...

Hi there, i've made an Exit button. I want it to exit excel when clicked, but all i managed to do is close the workbook. Is there any way at all to close Excel? or is the furthest it goes is closing a workbook?

For Each w In Application.Workbooks
w.Save
Next w
Application.Quit

I think that does it, havent tested it yet though!,, might be better to
do the save first and then time delay the quit as it will be real slow
on a big workbook

HTH

Duncan

Hi Bonbon

use Application.Quit method to close excel

Thanks
Xcelion

"Bonbon" wrote:

>
> Hi there, i've made an Exit button. I want it to exit excel when
> clicked, but all i managed to do is close the workbook. Is there any
> way at all to close Excel? or is the furthest it goes is closing a
> workbook?
>
>
> --
> Bonbon
> ------------------------------------------------------------------------
> Bonbon's Profile: http://www.excelforum.com/member.php...o&userid=31866
> View this thread: http://www.excelforum.com/showthread...hreadid=532192
>
>

Originally Posted by Duncan

For Each w In Application.Workbooks
w.Save
Next w
Application.Quit

I think that does it, havent tested it yet though!,, might be better to
do the save first and then time delay the quit as it will be real slow
on a big workbook

HTH

Duncan

Hi thanks for both the replies! But Duncan i dont understand the 'w' is it workbook or something?

Yep, exactly right, its just to save each workbook open or else it will
pop up and say "do you want to save"

Duncan

Ah thank you, it worked great!