Lotuscript and vba

HCL Domino Domino Forum
1

How is following vba written in Lotusscript?

ActiveDocument.Tables(1).Rows(1).Cells(1).Delete _

    ShiftCells:=wdDeleteCellsEntireRow

I can’t figure out how to write the second line.

2

Subject: Lotuscript and vba

First, You must translate the constant “wdDeleteCellsEntireRow” into a number since this constant isn’t a part of LotusScript:

Const wdDeleteCellsEntireRow = 2

Next, LotusScript can’t handle arguments called in the format that is specified by Word: ShiftCells:=

You must call the functions with all parameters in correct order (specified in the object model). Since the Delete method only has one argument, this is quite simple:

ActiveDocument.Tables(1).rows(1).Cells(1).Delete(wdDeleteCellsEntireRow)

or it is the same as

ActiveDocument.Tables(1).rows(1).Cells(1).Delete(2)

hth

3

Subject: THANK_YOU