Error Reading Esxcel Comment

[anubis]

I am experiencing a error when I try to read a cell comment when a comment does not exist.  I have reported this as bug but the moderators have said this is this is a consequence of the recent change in how COM errors are dealt with.  Offending code is below along with the message that appears in the console window.  I tried installing a COM error handler, but the code does not trigger the handler.  Is anybody else experiencing this issue and have you found a solution.  The code works perfectly if the cell has a comment.

$sStr = $oExcel.Cells($iRow, $iColumn).Comment.Text
$sStr = $oExcel.Cells($iRow, $iColumn).Comment^ ERROR

 

 

[water]

Welcome to AutoIt and the forum!
My suggestion: Use the Excel UDF that comes with AutoIt. It does the COM error handling stuff for you. Remember that _Excel_RangeRead can only read the comment of a single cell (Excel limitation).

Edited August 2, 2015 by water

[anubis]

I figured it out.  I adjusted my code to test to see if the Comment object exists before I try to read the text.  IsObj($oExcel.Cells($irRow, $iColumn).Comment) does the trick.  IsObj reports failure if a comment does not exist.

BTW, the Excel UDF does not include functions for Comments so it is not much help in that regard. 

[water]

Ops, you are correct. That is still in the pipeline.