Clsong Excel

[Guest]

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

 

[Norman Jones]

Hi Mark,

Try:

Application.Quit

 

[NickHK]

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 require:
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

 

[Guest]

Hi,
Not quit what I wanted but this does work

ThisWorkbook.Save
Application.Quit