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?


--
Bonbon
------------------------------------------------------------------------
Bonbon's Profile: http://www.excelforum.com/member.php...o&userid=31866
View this thread: http://www.excelforum.com/showthread...hreadid=532192

Macro Code for closing excel...
 

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

Macro Code for closing excel...
 

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

Macro Code for closing excel...
 

Duncan Wrote:
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?


--
Bonbon
------------------------------------------------------------------------
Bonbon's Profile: http://www.excelforum.com/member.php...o&userid=31866
View this thread: http://www.excelforum.com/showthread...hreadid=532192

Macro Code for closing excel...
 

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

Duncan

Macro Code for closing excel...
 

Ah thank you, it worked great! :)


--
Bonbon
------------------------------------------------------------------------
Bonbon's Profile: http://www.excelforum.com/member.php...o&userid=31866
View this thread: http://www.excelforum.com/showthread...hreadid=532192