SAP OLE excel - To Maximize the window

[Former Member]

Hi All,

Can anybody give me the solution of maximizing the window through OLE in excel.

Thanks in advance,

Swapna

[former_member189059]

Hello,

Try this

DATA:   EXCEL     TYPE OLE2_OBJECT.
CREATE OBJECT EXCEL 'EXCEL.APPLICATION'.

*** other activities ***

set PROPERTY OF EXCEL 'WindowState' = 3.

[Former Member]

Hi Kris,

Thank you for a quick response. It is working fine, but... as soon as this statement is executed an excel sheet is opened before the complete execution of the report. Can you tell me how to avoid this?

Regards,

Swapna.

[Former Member]

Hi Kris,

Thank you for a quick response. It is working fine, but... as soon as this statement is executed an excel sheet is opened before the complete execution of the report. Can you tell me how to avoid this?

Regards,

Swapna.

[Former Member]

Hi,

Please use the below code for hiding the excel sheet.

SET PROPERTY OF EXCEL 'visible' = 0.

Regards,

Kiran