You need to change all of the 'xl<things>' to numeric values.

Bring up the VBA editor

Bring up the browser (I think it's F12)

Find the attribute you're looking for and you'll see the numeric value for it.

I can't find a quick link, but in one of the forums there is a post that describes how to convert VBA into LS. This is helpful for what you're trying to do since the format VBA generates may not work directly in Notes/LS.

There are lots of posts going back to the 4/5 forum on this topic. You may also want to poke around OpenNTF.org for more examples.

You need to change all of the 'xl<things>' to numeric values.

Bring up the VBA editor

Bring up the browser (I think it's F12)

Find the attribute you're looking for and you'll see the numeric value for it.

I can't find a quick link, but in one of the forums there is a post that describes how to convert VBA into LS. This is helpful for what you're trying to do since the format VBA generates may not work directly in Notes/LS.

There are lots of posts going back to the 4/5 forum on this topic. You may also want to poke around OpenNTF.org for more examples.

Hi,

I'm using this code to add border:

ForAll cell In xlsheet.Range("A"+Cstr(firstrow)).Resize(x, 8)
            With cell
                '    .BorderAround xlContinuous, xlThin
                .BorderAround 1,2
            End With
 End ForAll

You can find Excel constants here: http://www.smarterdatacollection.com/Blog/?p=374

Attila