Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Killing Excel :)
Hi ,
I use the task scheduler to run Excel Macros nightly. Each morning I have to kill Excel process :( However, I use 'Application.quit' syntax at the end of each macro and I set ObjXl=Nothing How can I automatically kill the process or what can be done to avoid this 'Excel TSR' ? OS:Win2000 Excel 2000 TIA, Nicky. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Killing Excel :)
Hi Nicolas,
Are you trying to close Excel from within Excel VBA? If so, you may want to do something like this before you invoke the Quit method: Sub PrepareToQuit() Dim wb As Workbook For Each wb In Workbooks wb.Saved=True Next wb End Sub That will mark all open workbooks as saved already, so Excel shouldn't hang out in the background when you Quit. Of course, if you actually want to save any of the files, you should do that explicitly. -- Regards, Jake Marx www.longhead.com Nicolas Mainczyk wrote: Hi , I use the task scheduler to run Excel Macros nightly. Each morning I have to kill Excel process :( However, I use 'Application.quit' syntax at the end of each macro and I set ObjXl=Nothing How can I automatically kill the process or what can be done to avoid this 'Excel TSR' ? OS:Win2000 Excel 2000 TIA, Nicky. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple problem for you all....killing me though | Excel Discussion (Misc queries) | |||
Expiring/Killing Macro(s) | Excel Discussion (Misc queries) | |||
Data collation killing me!! | Excel Worksheet Functions | |||
Finding and killing all Access queries in an Excel spreadsheet | Links and Linking in Excel | |||
VBA loop is killing me! | Excel Discussion (Misc queries) |