How to check excel cell comment exist or not?

[ashly]

I had googled such topic and tried all they said but still cannot find a helpful answer.

Below script is what i use, and it always stop with error "The requested action with this object has failed." when the cell has no comment.

$sComment = $oTM.Worksheets($sWorkSheetName).Range($sColLetter & $j).Comment.Text

If $sComment = "" Then

     ......

EndIf

If there's someone can help me that would be great.  

[water]

It depends on the version of AutoIt you are using.

[water]

$oComment = $oTM.Worksheets($sWorkSheetName).Range($sColLetter & $j).Comment ; Returns the Comment object if there is a comment
If Isobj($oComment) Then $sComment = $oComment.Text

Add a COM error handler if you are running AutoIt > 3.3.12.0.

 

 

 

[ashly]

Thank u sooooooo much!!

It works with v.3.3.14.2 i'm running.

[water]