| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I close/exit Excel programmatically
I have several Excel files that I run automatically overnight. Excel remains
open after each file has run and closed. Thus, I have several sessions of Excel open. This is a problem over the weekend. Is there something I can add to the VB code that will close Excel after the file processing is done? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I close/exit Excel programmatically
application.displayalerts = false
application.quit Make darn sure that you have saved everything before you run this code. It closes things without asking if you would like to save. -- HTH... Jim Thomlinson "Jesse" wrote: I have several Excel files that I run automatically overnight. Excel remains open after each file has run and closed. Thus, I have several sessions of Excel open. This is a problem over the weekend. Is there something I can add to the VB code that will close Excel after the file processing is done? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I close/exit Excel programmatically
Look in help at the Quit command
-- Regards, Tom Ogilvy "Jesse" wrote in message ... I have several Excel files that I run automatically overnight. Excel remains open after each file has run and closed. Thus, I have several sessions of Excel open. This is a problem over the weekend. Is there something I can add to the VB code that will close Excel after the file processing is done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I close all workbooks and exit excel with one click? | Excel Discussion (Misc queries) | |||
| Exit Excel programmatically | Excel Programming | |||
| Close and Exit Excel | Excel Programming | |||
| Close and Exit Excel | Excel Programming | |||
| programmatically close help file before Excel closes? | Excel Programming | |||
Linear Mode
