How can I format an Excel spreadsheet with Notes?
I want to send information to an Excel spreadsheet. That works fine, but I would also like to be able to format the spreadsheet. Specifically, how do I tell it to center the text in a column? In Excel, a macro creates these lines:
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlBottom
end With
But Notes doesn't understand xlCenter and xlBottom, so what codes am I supposed to use?
These are numeric constants defined in Excel VB, but not in LotusScript. To discover their values, create an Excel macro that displays them in a MsgBox:
Sub snoopy()
MsgBox "xlCenter = " & xlCenter & ", xlBottom = " & xlBottom
End Sub
For me, this generates the following output:
xlCenter = -4108, xlBottom = -4107
Now you can make your LotusScript code contain those same constants by adding the following statements in your Declarations section:
Const xlCenter = -4108 Const xlBottom = -4107
(You could just use the numbers in your code instead of constant names, but the constants make your code more readable).