Skip to Content
avatar image
Former Member

MS_EXCEL_OLE_STANDARD_DAT Excel sheet shout not open

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 19, 2009 at 06:08 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 19, 2009 at 06:31 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 19, 2009 at 08:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded