Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

Excel Comment

I am trying to add a comment to excel through automation. using the following
code:
osheet.range("H"+alltrim(str(NBEG))).addcomment
osheet.range("H"+alltrim(str(NBEG))).comment.text="My text"
Keep getting comment is not a object. Hoping someone could help me out.
[284 byte] By [Lori] at [2007-11-10 12:48:59]
# 1 Re: Excel Comment
Hello, Lori!
You wrote on 24 Mar 2003 11:46:10 -0800:

L> I am trying to add a comment to excel through automation. using the
L> following code:
L> osheet.range("H"+alltrim(str(NBEG))).addcomment
L> osheet.range("H"+alltrim(str(NBEG))).comment.text="My text"

L> Keep getting comment is not a object. Hoping someone could help me out.

Try this:
osheet.range("H"+alltrim(str(NBEG))).addcomment("My text")
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8
Eric den Doop at 2007-11-11 23:51:24 >