Problem with working with Excel

[atzoref]

Hi,

My script refuse to stop its proccess until I do it by myself with "Stop Executing"

I see this error in the log:

C:\Program Files (x86)\AutoIt3\Include\Excel.au3 (416) : ==> The requested action with this object has failed.:

If $fSave Then $oExcel.ActiveWorkBook.Save()

If $fSave Then $oExcel.ActiveWorkBook.Save()^ ERROR

Why I get this?

The functions of the excel which I work with are:

$oExcel = _ExcelBookOpen($)

_ExcelReadCell($oExcel, $, $)

_ExcelBookClose($oExcel)

Thanks.

Edited July 10, 2012 by atzoref

[water]

Which version of Excel do you run? The 32 or the 64 bit version?

Which version of AutoIt do you run? Do you compile for 32 or 64 bit?

[atzoref]

Excel 2007 = 64 bit

Autoit v3

SciTE Version 2.28

I don't know about the "compile" I just run it with "GO" on tools menu on SciTE

[water]

The 64 bit version of Office seems to be unreliable and is not recommended by MS itself. There has been a discussion on this forum some time ago (sorry, don't have the time to search for it right now).

Everyone recommends the 32 bit version opf Office.

You have to make sure that the AutoIt script is compiled/run with the same bitness as Office.

Add "#AutoIt3Wrapper_UseX64=Y" at the top of your script to run/compile it for 64 bit and see what you get.

[atzoref]

It seems that the problem was with the function:

_ExcelBookClose($oExcel)

So I just using now: WinClose("Excel")

and it is ok now.

[water]

The discussion I was referring to can be found

[atzoref]

When I press F5 on SciTE, how it compile the script? 32 or 64?

[water]

As I mentioned in post #4 add the #AutoIt3Wrapper_UseX64 directive.