ole excel application from abap

[Former Member]

Hi all ,

I an calling one excel application from abap . I don't want to make excel file visible , but insted want to save and close the file , by using method

saveas for excel application and later i want to see the file . file name i want to store in a variable .

eg :

CALL METHOD OF H_EXCEL 'FILESAVEAS' = RC

EXPORTING #1 = filename .

Can it be possible ?

regards,

SA

[Former Member]

Hi all ,

I an calling one excel application from abap . I don't want to make excel file visible , but insted want to save and close the file , by using method

saveas for excel application and later i want to see the file . file name i want to store in a variable .

eg :

CALL METHOD OF H_EXCEL 'FILESAVEAS' = RC

EXPORTING #1 = filename .

Can it be possible ?

regards,

SA

[Former Member]

hi

i simpler method will be to use the function modules for this purpose.

CALL FUNCTION 'F4_FILENAME'

• EXPORTING

• PROGRAM_NAME = SYST-CPROG

• DYNPRO_NUMBER = SYST-DYNNR

• FIELD_NAME = ' '

IMPORTING

file_name = file_name .

lc_filename = file_name.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

• BIN_FILESIZE =

filename = lc_filename

filetype = 'DAT'

TABLES

data_tab = gt_itab.

IF sy-subrc <> 0.

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

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

ENDIF.

Fn module F4_filename will prompt for the name of the file to be saved and GUI_DOWNLOAD will save the file.

gt_itab is the internal table containing the data to be stored in excel.

[sourabhshah]

hi,

See if this link is useful

http://help.sap.com/saphelp_erp2005vp/helpdata/en/59/ae3d25488f11d189490000e829fbbd/frameset.htm

Regards,

Sourabh