MS_EXCEL_OLE_STANDARD_DAT Excel sheet shout not open

[Former Member]

Hi,

I am using function module MS_EXCEL_OLE_STANDARD_DAT to download file to excel format but here if I am executing the report immediately before output excel sheet will open, I donu2019t want to see the excel sheet in sap i wants to see only presentation server only.

Kindly help me how to avoid output in this excel sheet on SAP.

Thanks in advance

Rajendran

[Former Member]

Hi,

After creating the OLE object you will have to set the property of the excel for visibility as zero

SET PROPERTY OF EXCEL 'Visible' = 0.

Vikranth

[Former Member]

Kindly provide sample code which one working fine

[Former Member]

CALL FUNCTION 'MS_EXCEL_OLE_STANDARD_DAT'

EXPORTING

file_name = 'C:\Users\New\Desktop\doc3.CSV'

CREATE_PIVOT = 0

• DATA_SHEET_NAME = ' '

• PIVOT_SHEET_NAME = ' '

• PASSWORD = ' '

• PASSWORD_OPTION = 0

VISIBLE = '0'

No_DIALOG = 'X'

TABLES

• PIVOT_FIELD_TAB =

DATA_TAB = t_deli_final

• FIELDNAMES =

EXCEPTIONS

FILE_NOT_EXIST = 1

FILENAME_EXPECTED = 2

COMMUNICATION_ERROR = 3

OLE_OBJECT_METHOD_ERROR = 4

OLE_OBJECT_PROPERTY_ERROR = 5

INVALID_FILENAME = 6

INVALID_PIVOT_FIELDS = 7

DOWNLOAD_PROBLEM = 8

OTHERS = 9

.

IF sy-subrc <> 0.

• MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

• WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

But nothing will happen if i make to visible = 0 or 1.

[Former Member]

Hello Rajendran,

The set property of excel which i mention before works only for automation objects of OLE created using CREATE OBJECT syntax. For the FM MS_EXCEL_OLE_STANDARD_DAT, it seems it wont be possible to supress the opening of the excel . If you just want to download to presentation server, you could use the conventional GUI_DOWNLOAD for this.

PS: It would also be better if you could un-assign the p0ints given. So that it wont be misleading to others when they search later

Vikranth