Thread: Closing Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
STEVE BELL STEVE BELL is offline
external usenet poster
 
Posts: 692
Default 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