_ExcelReadSheetToArray doesn`t work

[Tweaky]

I use Win 7 64 bit and Office 2010 32bit.
$namen = _ExcelreadSheetToArray($oExcel, 1, 1, 10, 20) works fine. I get an array.
$namen = _ExcelreadSheetToArray($oExcel, 5, 1, 10, 20) doesn`t work.
I get @error = 3

[Jon]

You have to use 32bit autoit to access 32bit COM objects. Are you doing that?

[Tweaky]

Öh, sorry I don`t understand you.
I use the script uncompiled.

[Jon]

Are you running the script with AutoIt3.exe or AutoIt3_x64.exe?

[Tweaky]

I don`t know.
I press F5 when I am in SciTE an then the script is running

[Zedna]

Replying to Tweaky:

I don`t know.
I press F5 when I am in SciTE an then the script is running

Copy content of output window in Scite (at bottom), there are all needed information.

[Jon]

Try putting this at the top of your script, if it works then you were running the x64 version which can't talk to 32bit COM objects like Excel:

#AutoIt3Wrapper_UseX64=N

[Tweaky]

@Zedna

"C:\Program Files (x86)\AutoIt3\SciTE\AutoIt3Wrapper\AutoIt3Wrapper.exe" /run /prod /ErrorStdOut /in "E:\test.au3" /autoit3dir "C:\Program Files (x86)\AutoIt3" /UserParams

+>19:34:24 Starting AutoIt3Wrapper v.2.0.1.24 Environment(Language:0407 Keyboard:00000407 OS:WIN_7/Service Pack 1 CPU:X64 OS:X64)

Running AU3Check (1.54.19.0) from:C:\Program Files (x86)\AutoIt3

+>19:34:24 AU3Check ended.rc:0

Running:(3.3.6.1):C:\Program Files (x86)\AutoIt3\autoit3_x64.exe "E:\test.au3"

+>19:34:47 AutoIT3.exe ended.rc:0

Exit code: 0 Time: 24.200

@Jon
the same result

[Jon]

You're definately running the x64 version so it's expected that this won't work. Closing the bug. Start a discussion on the forum on how to get your scripts to run using the x86 version of autoit.