Excel file Opened and Closed still remained in Task Manager

[afzalw]

I have used the following code to open and close an excel file after working in it, but after the file is closed I checked the task manager it shows EXCEL.EXE * 32 in the process tab. Is there a way to remove this from task manager also when I close my excel workbook ?

Thanks

; Open the already existing Excel File
#include <Excel.au3>
$oExcel = ObjCreate("Excel.Application")

Local $sFilePath1 = @ScriptDir & "\Excel File.xlsm" ;This file should already exist
Local $oExcel = _ExcelBookOpen($sFilePath1)       ;Opening the file


$oExcel.application.quit  ;Closing the Excel Application

[Nessie]

Have you used _ExcelBookClose?

Hi!

[afzalw]

Have you used _ExcelBookClose?

Hi!

Yes, I did, it does not work. Is there any other way or a direct way to close excel.exe from Task Manager's Process Tab.

Thanks

[Nessie]

Very rude way:

If ProcessExists("excel.exe") Then
    ProcessClose("excel.exe")
EndIf

Hi!

[afzalw]

Very rude way:

If ProcessExists("excel.exe") Then
    ProcessClose("excel.exe")
EndIf

Hi!

Thankyou, worked like I wanted.

[water]

You are mixing UDF functions and your own direct access.

Unfortunately the Excel UDF doesn't support the new file formats of Excel 2007 and later.

Please have a look at my ExcelEX UDF (for download please check my signature).

[Nessie]

Thankyou, worked like I wanted.

Glad to help you.

[afzalw]

Glad to help you.

If I have to open Excel again afterwards do I have to use $oExcel = ObjCreate("Excel.Application") again

or

just use

Local $sFilePath1 = @ScriptDir & "Master File.xlsm" ;This file should already exist

Local $oExcel = _ExcelBookOpen($sFilePath1) ;Opening the file

[Nessie]

I think that if you dont have closed the $oExcel object you dont need to re-use:

$oExcel = ObjCreate("Excel.Application")

So

$oExcel = _ExcelBookOpen($sFilePath1)

should be fine.

Hi!

Edited April 17, 2013 by Nessie

[lolipop]

set $oExcel = 0 at the end