Closing Excel from a Macro
 

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

Closing Excel from a Macro
 

Application.quit

Rgds



-----Original Message-----
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
.

Closing Excel from a Macro
 

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
-----Original Message-----
Application.quit

Rgds



-----Original Message-----
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
.

.

Closing Excel from a Macro
 

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

On Wed, 11 Aug 2004 12:08:35 -0700,
wrote:

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
-----Original Message-----
Application.quit

Rgds



-----Original Message-----
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
.

.

Closing Excel from a Macro
 

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


Anything else??

Thanks!
Jimmy
-----Original Message-----
Only one spreasheet running and still does not close
excel
application,


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

On Wed, 11 Aug 2004 12:08:35 -0700,

wrote:

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
-----Original Message-----
Application.quit

Rgds



-----Original Message-----
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
.

.


.

.

Closing Excel from a Macro
 

I think it was Excel.Quit statement
wrote in message
...
Yes... Only one excel open and still does not close excel.


Anything else??

Thanks!
Jimmy
-----Original Message-----
Only one spreasheet running and still does not close
excel
application,


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

On Wed, 11 Aug 2004 12:08:35 -0700,

wrote:

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
-----Original Message-----
Application.quit

Rgds



-----Original Message-----
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
.

.


.

.

Closing Excel from a Macro
 

Hi Jimmy... try

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

hope this helps...

seeya ste