View Single Post
  #1 (permalink)  
Old September 28th, 2006, 07:40 PM
bab02 bab02 is offline
Authorized User
Join Date: Jul 2004
Location: , , .
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default end process in task mgr

 I have a .mdb that creates a excel spreadsheet. The .mdb saves the spreadsheet and releases excel from memory.

appExcel.close 'close excel application
set appExcel to nothing 'releasing Excel application
set bks to nothing 'releasing the workbook
set wks to nothing 'releasing the worksheet

However, if you open the task mgr after running the script, I still see Excel.exe under the process tab. I have to manually select excel.exe in the task mgr and click end process.

If I dont do this and try tu run the script (in access) again, it error out. Is there another call to end this process programatically from access? Is it an API call?

Reply With Quote