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:
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlBottom
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:
MsgBox "xlCenter = " & xlCenter & ", xlBottom = " & xlBottom
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).
This was first published in May 2003