Variable must be of type object

[grzesiek]

When I use excel sometimes an error appears  'Variable must be of type object' which terminates the script, how can I prevent this? I would like to silently receive an error and not terminate the script.

This is an example, which when executed throws an error.

Local $oErrorHandler = ObjEvent("AutoIt.Error", "_ErrFunc")
Func _ErrFunc($oError)
EndFunc

$oExcel = ObjCreate("Excel.Application")
$oExcel.visible = 1
$oExcel.workbooks.add()
WinClose(HWnd($oExcel.hwnd))
$oExcel.cells(1, 1).value = 1

 

[jdelaney]

Check that a variable is an object first. ..isobj ()

[grzesiek]

IsObj returns true even if excel is closed. But anyway it's not practical to check object everytime it is used.

[jdelaney]

I disagree with you.   you should never check a property or class of an object without verifying the parent exists. ..specifically is obj on the oexcell.cells (1,1).

 

I also don't think that i should have to convert python integers to strings for console outputs. ..but you have to work with what you are given

Edited December 12, 2018 by jdelaney

[grzesiek]

So I will have to do this like in the example below, assign cell to a variable, and then the error doesn't appear.

 

Local $oErrorHandler = ObjEvent("AutoIt.Error", "_ErrFunc")
Func _ErrFunc($oError)
EndFunc

$oExcel = ObjCreate("Excel.Application")
$oExcel.visible = 1
$oExcel.workbooks.add()
WinClose(HWnd($oExcel.hwnd))
$oCell = $oExcel.cells(1, 1)
$oCell.value = 1

 

[water]

I suggest to use the Excel UDF that comes with AutoIt - error handling included