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