Closing Excel from a Macro

[Jimmy]

Hello,

A have a macro that emails out certaing information and
would like to closed or Exit Excel once code is executed.
Right now I have a Mssage box that let's the user know it
finished emailing the information but it advises the user
to please close excel.

How can I close Excel after code is executed?

Thanks in advance!
Jimmy

 

[Rog]

Application.quit

Rgds

 

[Guest]

Yes... Only one excel open and still does not close excel.


Anything else??

Thanks!
Jimmy

 

[Max Potters]

I think it was Excel.Quit statement

Yes... Only one excel open and still does not close excel.


Anything else??

Thanks!
Jimmy

 

[ste mac]

Hi Jimmy... try

Sub CloseNoSave()
ThisWorkbook.Saved = True
Application.Quit
End Sub

hope this helps...

seeya ste