excel example error

[faustf]

hi  guy  i have  installed last version of  autoit  use  windows 7  32 bit 

when  open  a  example  of  excel  ,  _Excel_RangeWrite  (for  example ) i have  this  errror= 1 @extended = -2147221005

 

why ? 

i  use  second  code 

#include <Array.au3>
#include <Excel.au3>
#include <MsgBoxConstants.au3>

; Create application object and create a new workbook
Local $oAppl = _Excel_Open()
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeWrite Example", "Error creating the Excel application object." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
Local $oWorkbook = _Excel_BookNew($oAppl)
If @error Then
    MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeWrite Example", "Error creating the new workbook." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
    _Excel_Close($oAppl)
    Exit
EndIf

; *****************************************************************************
; Write a 1D array to the active sheet in the active workbook
; *****************************************************************************
Local $aArray1D[3] = ["AA", "BB", "CC"]
_Excel_RangeWrite($oWorkbook, $oWorkbook.Activesheet, $aArray1D, "A3")
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeWrite Example 2", "Error writing to worksheet." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeWrite Example 2", "1D array successfully written.")

thankz at alll

[water]

Which version of Excel do you run?

Does any of the other examples for _Excel_RangeWrite work?

[faustf]

i  have  excel read  and  libre office

[faustf]

i install excell and  now  go  sorry  

[water]

I'm glad there is no problem with the Excel examples

[JLogan3o13]

There is a libre office UDF in the Examples forum. You will see upon inspection that the object model is completely different; no wonder this did not work for you.