Skip to main content

How to get AcuCobol to Insert a row into a shared Excel document

  • July 9, 2012
  • 0 replies
  • 0 views

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?

David


#InsertRowExcelShared

0 replies

Be the first to reply!