If You want to add a comment to Cell A3 Then Passed Input to action "A3"
View attachment 4050
I Hope it will solve your issue.
Best,
Sachin
Root Cause for above mentioned problem is .Internal : Could not execute code stage because exception thrown by code stage: Exception from HRESULT: 0x800A03EC
This works perfect for appending comment, thanks again for your prompt help.Hi Kiss,
If you want append new comment to existing comment
Copy the bellow code and paste in your Existing code stage.
Dim str As String
Dim FinalComment As String
str=GetWorkbook(handle, "").ActiveSheet.Range(cellref,cellref).Comment.text
GetWorkbook(handle, "").ActiveSheet.Range(cellref,cellref).Comment.Delete
FinalComment= str & Comment
GetWorkbook(handle, "").ActiveSheet.Range(cellref,cellref).AddComment(FinalComment)
Note :- Delete your Existing code from your code stage and do not change input and output Parameter
I hope it will help you.
This works perfect for appending comment, thanks again for your prompt helpHi Kiss,
If you want append new comment to existing comment
Copy the bellow code and paste in your Existing code stage.
Dim str As String
Dim FinalComment As String
str=GetWorkbook(handle, "").ActiveSheet.Range(cellref,cellref).Comment.text
GetWorkbook(handle, "").ActiveSheet.Range(cellref,cellref).Comment.Delete
FinalComment= str & Comment
GetWorkbook(handle, "").ActiveSheet.Range(cellref,cellref).AddComment(FinalComment)
Note :- Delete your Existing code from your code stage and do not change input and output Parameter
I hope it will help you.
@Sachin_KharmaleHi Kiss,
If you want append new comment to existing comment
Copy the bellow code and paste in your Existing code stage.
Dim str As String
Dim FinalComment As String
str=GetWorkbook(handle, "").ActiveSheet.Range(cellref,cellref).Comment.text
GetWorkbook(handle, "").ActiveSheet.Range(cellref,cellref).Comment.Delete
FinalComment= str & Comment
GetWorkbook(handle, "").ActiveSheet.Range(cellref,cellref).AddComment(FinalComment)
Note :- Delete your Existing code from your code stage and do not change input and output Parameter
I hope it will help you.