Clsong Excel
 

Hi,
' Save And Close
ActiveWindow.Close savechanges:=True

this closes and saves to workbook but leaves Excel still running, I want to
close Excel as well.

Any ideas

MarkS

Clsong Excel
 

Hi Mark,

Try:

Application.Quit


---
Regards,
Norman


"MarkS" wrote in message
...
Hi,
' Save And Close
ActiveWindow.Close savechanges:=True

this closes and saves to workbook but leaves Excel still running, I want
to
close Excel as well.

Any ideas

MarkS

Clsong Excel
 

Mark,
For your information your code does not necessarily close and save the
workbook.
If the workbook only has a single window, then it does as you expect,
otherwise it only closes the activewindow.

You should use one of these, depending on the location of the code and what
you requi
ActiveWorkbook.Close True
ThisWorkbook.Close True
Workbooks(1).Close True
Workbooks("Somename.xls").Close True

As for closing Excel
Application.Quit

although you may get prompted it other WBs are open/changes made.

NickHK

"MarkS" wrote in message
...
Hi,
' Save And Close
ActiveWindow.Close savechanges:=True

this closes and saves to workbook but leaves Excel still running, I want
to
close Excel as well.

Any ideas

MarkS

Clsong Excel
 

Hi,
Not quit what I wanted but this does work

ThisWorkbook.Save
Application.Quit


"NickHK" wrote:

Mark,
For your information your code does not necessarily close and save the
workbook.
If the workbook only has a single window, then it does as you expect,
otherwise it only closes the activewindow.

You should use one of these, depending on the location of the code and what
you requi
ActiveWorkbook.Close True
ThisWorkbook.Close True
Workbooks(1).Close True
Workbooks("Somename.xls").Close True

As for closing Excel
Application.Quit

although you may get prompted it other WBs are open/changes made.

NickHK

"MarkS" wrote in message
...
Hi,
' Save And Close
ActiveWindow.Close savechanges:=True

this closes and saves to workbook but leaves Excel still running, I want
to
close Excel as well.

Any ideas

MarkS