Excel Guru's, Can this be done?

HCL Domino Domino Forum
1

Hello,I have been exporting Notes data into Excel reports for some time now. I have come across a VB command that I am unable to re-create in LS. Here is the VB (Excel Macro) code,

Range("H5").Select

Range("H5").AddComment

Range("H5").Comment.Visible = False

Range("H5").Comment.Text Text:=" :" & Chr(10) & "add comment here"

Range("H9").Select

In the 4th line there is a space between ‘Text’ and ‘Text’, does anyone know how to format this command in script? My only other thought was using the windows API, but before I went down that road, wanted to see if someone knew the answer.

Thanks,

2

Subject: Excel Guru’s, Can this be done?

A quick search on the forum yields this post:

http://www-10.lotus.com/ldd/nd6forum.nsf/55c38d716d632d9b8525689b005ba1c0/3d6ff4d1c0dd41e985256d82007b3a8f?OpenDocument&Highlight=0,excel,comment

Dan

3

Subject: RE: Excel Guru’s, Can this be done?

Also, the VB Reference for excel indicates the following syntax:

expression.Text(Text, Start, Overwrite)

expression Required. An expression that returns a Comment object.

Text Optional Variant. The text to be added.

Start Optional Variant. The character number where the added text will be placed. If this argument is omitted, any existing text in the comment is deleted.

Overwrite Optional Variant. True to overwrite the existing text. The default value is False (text is inserted).

4

Subject: RE: Excel Guru’s, Can this be done?

Thank You Dan and Peter,

I must be search challenged this morning ;).