Close the entire application of excel

[water]

Then back to my question from post #18.

[mpower]

Then back to my question from post #18.

There's no @error as the _Excel_Close function returns 1.

[water]

I justed tested wih Excel 2010 on Windows 7 64 bit. Works fine.

• Is there anything special in the Excel workbook like macros etc?
• Which version of AutoIt do you run?
• Do you run the 32 or 64 bit version of Excel?

Edited July 30, 2015 by water

[mpower]

I justed tested wih Excel 2010 on Windows 7 64 bit. Works fine.

• Is there anything special in the Excel workbook like macros etc?
• Which version of AutoIt do you run?
• Do you run the 32 or 64 bit version of Excel?

Hmm.. No, nothing special, even an empty workbook still has the same result.

AutoIt is latest: v3.3.14.1

Excel 2013 15.0.4737.1000 32-bit

Windows 7 64-bit

 

I've added some checks and my results are further down below

$aProcesses = ProcessList("Excel.exe")
    ConsoleWrite($aProcesses[0][0] & " Excel instance(s) running." & @CRLF)
    ConsoleWrite('Started Processing ' & $file & @CRLF)
    $oExcel = _Excel_Open(False, False, False, False, True)
    $oWorkbook = _Excel_BookOpen($oExcel, $file, True)
    $aOrgArray = _Excel_RangeRead($oWorkbook)
    $oWorkbook = _Excel_BookClose($oWorkbook, False)
    $oExcelClose = _Excel_Close($oExcel, False, True)
    Sleep(2000)
    ConsoleWrite('Finished Processing ' & $file & @CRLF)
    ConsoleWrite('$oExcelClose=' & $oExcelClose & '   |   @error=' & @error & '   |   @extended=' & @extended & @CRLF)
    $aProcesses = ProcessList("Excel.exe")
    ConsoleWrite($aProcesses[0][0] & " Excel instance(s) still running." & @CRLF)

Console result:

0 Excel instance(s) running.
Started Processing C:\Blank Workbook.xlsx
_Excel_Open() triggered
__Excel_CloseOnQuit triggered. $bNewState=True
_Excel_BookOpen() triggered
_Excel_BookClose() triggered
_Excel_Close() triggered. $bForceClose=True
__Excel_CloseOnQuit triggered. $bNewState=Default
__Excel_CloseOnQuit triggered. $bNewState=False
Finished Processing C:\Blank Workbook.xlsx
$oExcelClose=1   |   @error=0   |   @extended=0
1 Excel instance(s) still running.

 

I have also confirmed that this behaviour is unique to having a 32-bit version of Office on a 64-bit version of Windows. Another system that has both 64-bit OS and 64-bit Office appears to work fine. So it's a mixed software architecture issue. Any ideas on how to resolve?

Edited July 31, 2015 by mpower

[mpower]

EDIT: Sorry ignore this post - notified mod to delete - posted wrong information

Edited July 31, 2015 by mpower

[water]

Would it be possible to test this with AutoIt 3.3.12.0?

[JohnOne]

As a sanity check, add #RequireAdmin to script.

[mpower]

Would it be possible to test this with AutoIt 3.3.12.0?

Just tested with 3.3.12.0 and no change in behaviour. Excel.exe  still remains in Task Manager.

As a sanity check, add #RequireAdmin to script.

Tried with #RequireAdmin also - no change.

 

Edited July 31, 2015 by mpower

[TheDcoder]

@mpower Why not use this?:

Run(@ComSpec & " /c " & 'taskkill /im excel.exe /f /t', "", @SW_HIDE)

 

[JohnOne]

Because ProcessClose would be sufficient to do that, but would not guarantee closing the correct instance.

Also, the point is that it should work, but it appears not to be.

[JohnOne]

I forgot I had Excel installed. I tried it on version 3.3.12.0 and it closes fine for me whether I close the workbook or not, or whether I set $bForceClose to true or false.

[mpower]

I forgot I had Excel installed. I tried it on version 3.3.12.0 and it closes fine for me whether I close the workbook or not, or whether I set $bForceClose to true or false.

Are you running 32-bit Office on 64-bit Windows though?

[JohnOne]

No. both 32

 

[water]

I forgot I had Excel installed. I tried it on version 3.3.12.0 and it closes fine for me whether I close the workbook or not, or whether I set $bForceClose to true or false.

You are talking about Excel 2013?

[JohnOne]

Yes, Excel 2013.

[water]

JohnOne,

would it be possible to test with 3.3.14.1?

[JohnOne]

Sure, I'll install it now. and report back.

[water]

Thanks a lot!
We will then know (hopefully) if the problem is Autoit or Excel related.

[JohnOne]

Tried it a dozen times, it closed just fine on each occasion.

Tried with $bForceClose true and false, and with excel visible and not.

Exactly as I did with 3.3.12.0

[JohnOne]

Thinking back, when I was working on a project with excel (I'm sure you were helping me) I had similar problem to OP.

I'll try to find the thread.