_ExcelBookClose problem

[rosaz]

Hello, I'm having trouble with what I know should be a basic bit of code, but which is proving difficult! The _ExcelBookClose command just isn't working... after running the script (below) the Excel spreadsheet window will just sit there, and not respond to anything until I have to manually close it. It seems almost like instead of closing it, the command just turns off screen updating for it but that doesn't make any sense... Anyways, here's my code, please help!!!

[/code]#include <Excel.au3>
$excel = _ExcelBookNew(1)
_ExcelBookClose($excel)[code]

[MrMitchell]

What is the Return value and @error of the _ExcelBookClose() function?

May as well get the same for _ExcelBookNew() as well...

Edited April 20, 2010 by MrMitchell

[rosaz]

I'm still a newbie so I'm not sure how to get the return value on _ExcelBookClose, it's been giving me an error when I try to put something in front of it like:

$retval = _ExcelBookClose($excel)

But the @error is 1 (no object) even though when I do IsObj($excel) before the _ExcelBookClose command, it returns 1.

Very puzzling.

[MrMitchell]

Well dunno what to tell ya... I ran this:

#include <Excel.au3>
$excel = _ExcelBookNew(1)
$retval = _ExcelBookClose($excel)
$error = @error
ConsoleWrite("Return value of ExcelBookClose($excel) = " & $retval & " and $error = " & $error & @CRLF)

and got this:

Return value of ExcelBookClose($excel) = 1 and $error = 0

Were there other processes of Excel.exe running whether or not their windows were visible?

[water]

I'm a bit late but I have run into the same problem:

Your example script (posting #1) runs fine on my Windows XP SP2 machine with Office XP. But it doesn't work on Windows 7 with Excel 2010.

The problem is that Office XP returns the ObjName as "_Application" and Excel 2010 returns nothing. _ExcelBookClose checks for "_Application" and "_Workbook" and therefore sets @error to 1 as $sobName is blank.

This seems to be a problem with Excel because the example script for ObjName displays the object name for IE identical on XP and Windows 7.

I will open a new thread and see if it's an AutoIt or Excel bug.

Edited August 6, 2010 by water