Closing Excel from a Macro

J

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
 
G

Guest

Thanks!! But Excel is still open. The spreadsheet is
closed but the Excel application is still running.

Any way to close excel application?

Thanks in advance!
Jimmy
 
M

Myrna Larson

If the Application.Quit line doesn't work, then maybe you have multiple copies
of excel running.
 
G

Guest

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


Anything else??

Thanks!
Jimmy
 
S

ste mac

Hi Jimmy... try

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

hope this helps...

seeya ste
 
Top