| Author |
Variant from Excel
|
|
| Peter Krarup 2005-09-08, 9:24 am |
| Hello,
When I am reading the comment from a cell I get a type U using:
cmm = oExcel.Range( "G"+ltrim(str(ii)) ).comment.text
Is there any possibility to read the text?
Thanks in advance
Peter Krarup
| |
| Denis Finch 2005-09-09, 9:26 am |
| This worked for me:
oexcel.Range("G" + ii).select()
cmm = oexcel.selection.comment.text()
to write in the comment use this
oexcel.selection.comment.text("this is a test")
"Peter Krarup" <pk@force.dk> wrote in message
news:bPkUYiHtFHA.1232@news-server...
> Hello,
> When I am reading the comment from a cell I get a type U using:
> cmm = oExcel.Range( "G"+ltrim(str(ii)) ).comment.text
> Is there any possibility to read the text?
> Thanks in advance
> Peter Krarup
>
>
>
| |
| Peter Krarup 2005-10-27, 8:02 am |
| Thanks a lot, that works for me, too.
Kind regards
Peter Krarup
"Denis Finch" <dfinch2338@aol.com> wrote in message
news:cazA84TtFHA.1232@news-server...
> This worked for me:
>
> oexcel.Range("G" + ii).select()
> cmm = oexcel.selection.comment.text()
>
> to write in the comment use this
>
> oexcel.selection.comment.text("this is a test")
>
>
> "Peter Krarup" <pk@force.dk> wrote in message
> news:bPkUYiHtFHA.1232@news-server...
>
>
|
|
|
|