HWnd($oExcel.hwnd()) Problem

[StefanoVR]

Good afternoon to everybody.

I have a little problem with this code:

$oExcel = My_VerificaoExcelAperto ($oExcel)
If IsObj($oExcel) Then
MsgBox(0,"Verificato che è stato passato un oggetto","OK")
EndIf

$hwndEXCEL = HWnd($oExcel.hwnd())
MsgBox(0,"Handle",$hwndEXCEL )
WinActivate($oExcel)
My_ResizeFull2($hwndEXCEL)

The function My_VerificaoExcelAperto ($oExcel) checks if the object $oExcel exists, if not asks to the user the file and open it, anyway returns an Excel Object.

hwndEXCEL = HWnd($oExcel.hwnd())

$hwndEXCEL = HWnd($oExcel.hwnd()^ ERROR

->12:36:31 AutoIT3.exe ended.rc:1

>Exit code: 1 Time: 17.689

Autoit stops with this error and I can't understand why. Do you have any suggestion??

Edited April 24, 2013 by StefanoVR

[BrewManNH]

It's probably telling you that $oExcel isn't an object, and that you can't use it the way you're using it because of that.

Just opening an Excel sheet won't cause $oExcel to magically become an object, you need to attach to or open the Excel spreadsheet, before you can use that method.

[StefanoVR]

Just before the error I check

If IsObj($oExcel) Then

MsgBox(0,"Verificato che è stato passato un oggetto","OK")

EndIf

And Autoit recognize $oExcel as object. I open and attach to the spread sheet in the function.

[water]

Please have a look at my ExcelEX UDF, function _Excel_Open. I check for an existing Excel object using ObjGet. If I get an error Excel doesn't run and hence has to be started using ObjCreate.

For AutoIt > 3.3.8.1 you just check @error. For AutoIt <= 3.3.8.1 you need a COM error handler.