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
|