Closing Excel
This will close the application in Excel 2000.
[you may want to save your workbook first]
[or you can set the workbook
ThisWorkbook.Save = True
this is supposed to make Excel think the workbook is already saved]
Application.Quit
--
steveB
Remove "AYN" from email to respond
"Sunil Jayakumar" <sunil.jayakumar[at]gmail.com wrote in message
...
Hi,
I have an excel workbook with macros that calls macros in other workbooks,
and all this works well.
It executes the code, and closes the other workbooks fine, but I can't
figure out how to close the "host" workbook and exit excel completely,
rather than leaving an excel shell open.
Any ideas appreciated.
Warm regards
Sunil Jayakumar
|