How to get AcuCobol to Insert a row into a shared Excel document
The important factor is the Excel document is shared.
We have inserted data into non-shared docs by defining a range of cells (A:LastCol) and using an insert method including 'movedown' parameter so the effect is to insert a row.
The shared document is not allowing this method.
We are struggling to find the syntax that equates to 'Insert a row'.
e.g. Tied the following (one at a time!):
MODIFY hndWrkSh Range(WS-CELL-RANGE)::Insert(-4121)
MODIFY hndWrkSh Range(ws-row)::Insert(xlPatternDown)
MODIFY hndWrkSh Range("A5:A5")::Insert(xlInsertEntireRows)
Can anyone help?