Hanging process EXCEL.EXE

[guiAI]

Can't find any effective solution in the forum, except:

ProcessClose("excel.exe")

Any idea? Thanks.

Edited August 14, 2009 by guiAI

[somdcomputerguy]

WinClose

WinKill

[DCCD]

Can't find any effective solution in the forum, except:

ProcessClose("excel.exe")

Any idea? Thanks.

Huh?

[guiAI]

A little example:

#include <Excel.au3> 
$oExcel = _ExcelBookNew(0) 
_ExcelWriteCell($oExcel, "Some text", 3, 2) 
_ExcelBookSaveAs($oExcel, @DesktopDir & "\Test.xls", "xls", 0, 1) 
_ExcelBookClose($oExcel) 
MsgBox(0, "Before exiting...", "Please, check process excel.exe in Task Manager")

Until the Exit, process is hanging.

[reb]

A little example:

#include <Excel.au3> 
$oExcel = _ExcelBookNew(0) 
_ExcelWriteCell($oExcel, "Some text", 3, 2) 
_ExcelBookSaveAs($oExcel, @DesktopDir & "\Test.xls", "xls", 0, 1) 
_ExcelBookClose($oExcel) 
MsgBox(0, "Before exiting...", "Please, check process excel.exe in Task Manager")

Until the Exit, process is hanging.

This works

#include <Excel.au3>

$oExcel = _ExcelBookNew(0)

_ExcelWriteCell($oExcel, "Some text", 3, 2)

_ExcelBookSaveAs($oExcel, @DesktopDir & "\Test", "xls", 0, 1)

_ExcelBookClose($oExcel)

MsgBox(0, "Before exiting...", "Please, check process excel.exe in Task Manager")

REB

[SandelPerieanu]

OR

DllCall("User32.dll", "int", "EndTask", "hwnd", WinGetHandle("EXCEL"), "int", 0, "int", 1)

[guiAI]

This works

#include <Excel.au3>

$oExcel = _ExcelBookNew(0)

_ExcelWriteCell($oExcel, "Some text", 3, 2)

_ExcelBookSaveAs($oExcel, @DesktopDir & "\Test", "xls", 0, 1)

_ExcelBookClose($oExcel)

MsgBox(0, "Before exiting...", "Please, check process excel.exe in Task Manager")

This does not work for me: process EXCEL.EXE still running when MsgBox appears.

[Juvigy]

That is because you just close the wbook and not excel.

Put one

$oExcel.Quit

before the msgbox.

[guiAI]

That is because you just close the wbook and not excel.

Put one

$oExcel.Quit

before the msgbox.

Unfortunately your suggestion does not work for me (Excel 2007). Trying:

#include <Excel.au3> 
$oExcel = _ExcelBookNew(0) 
_ExcelWriteCell($oExcel, "Some text", 3, 2) 
_ExcelBookSaveAs($oExcel, @DesktopDir & "\Test", "xls", 0, 1) 
_ExcelBookClose($oExcel) 
$oExcel.Quit 
MsgBox(0, "Before exiting...", "Please, check process excel.exe in Task Manager")

process EXCEL.EXE is still running when MsgBox appears.

[Juvigy]

Try this one.It works for me:

$oExcel.Application.Quit
$oExcel=""

[Scriptonize]

#include <Excel.au3>
$oExcel = _ExcelBookNew(0)
_ExcelWriteCell($oExcel, "Some text", 3, 2)
_ExcelBookSaveAs($oExcel, @DesktopDir & "\Test", "xls", 0, 1)
_ExcelBookClose($oExcel)
$oExcel.Quit
MsgBox(0, "Before exiting...", "Please, check process excel.exe in Task Manager")

I'v tested the code with excel 2003 running on windows xp-sp3.

It works! >_<

[[EDIT; added tested code ]]

Edited August 14, 2009 by Scriptonize

[guiAI]

#include <Excel.au3>
$oExcel = _ExcelBookNew(0)
_ExcelWriteCell($oExcel, "Some text", 3, 2)
_ExcelBookSaveAs($oExcel, @DesktopDir & "\Test", "xls", 0, 1)
_ExcelBookClose($oExcel)
$oExcel = ""
MsgBox(0, "Before exiting...", "Please, check process excel.exe in Task Manager")

SOLVED.

Thanks Juvigy.

Edited August 15, 2009 by guiAI