How to make a field Middle Align Using OLE technique?

[Former Member]

Hi All,

Please tell me how to make a field Middle Align i.e. Align text so that it is centered between the top

and bottom of the cell.

Please find attached screenshot.

Thanks,

Teja.

[former_member225269]

Hi sharan,

Code as follows:

     CALL METHOD OF

          EXCEL_OBJ

               'RANGE' = CELL_OBJ

         EXPORTING

          #1 = RANGE.

     SET PROPERTY OF CELL_OBJ 'HorizontalAlignment' = 3.

     FREE OBJECT CELL_OBJ.

[Former Member]

Hi Vinson,

Thanks for replying.